Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Can I get more information from a LOGFILE?

5 posts in General Discussion Last posting was on 2008-04-21 14:15:12.0Z
Robert Paresi Posted on 2008-04-21 13:53:15.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
Subject: Can I get more information from a LOGFILE?
Lines: 28
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <480c9c4b$1@forums-1-dub>
Date: 21 Apr 2008 06:53:15 -0700
X-Trace: forums-1-dub 1208785995 10.22.241.152 (21 Apr 2008 06:53:15 -0700)
X-Original-Trace: 21 Apr 2008 06:53:15 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6827
Article PK: 5064

Hello,

I've extracted a logfile, and see where the problem keeps happening at the
users site. However, now I need to know more information like the exact
date and time, or the workstation this happened on.

Does the logfile contain more information than what I have extracted?

All I see is:

--COMMIT-1022-0335664605
COMMIT WORK
go
--BEGIN TRANSACTION-1022-0335664606
BEGIN TRANSACTION
go
--DELETE-1022-0335664607
DELETE FROM DBA.TABLES
WHERE TABLEID='DISC'
AND TABLENUM='50% Off Programs'
go


How can I find out more information like workstation name, process id,
connnection name, date, time or anything more than this?

Thank you.


"Nick Elson" < Posted on 2008-04-21 13:57:32.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <480c9c4b$1@forums-1-dub>
Subject: Re: Can I get more information from a LOGFILE?
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <480c9d4c@forums-1-dub>
Date: 21 Apr 2008 06:57:32 -0700
X-Trace: forums-1-dub 1208786252 10.22.241.152 (21 Apr 2008 06:57:32 -0700)
X-Original-Trace: 21 Apr 2008 06:57:32 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6828
Article PK: 5065

Maybe if you enable auditing that will help out more in
this case.

Session-specific information is not tracked in the
transaction log unless you enable auditing.

"Robert Paresi" <FirstInitialLastName@innquest.com> wrote in message
news:480c9c4b$1@forums-1-dub...
> Hello,
>
> I've extracted a logfile, and see where the problem keeps happening at the
> users site. However, now I need to know more information like the exact
> date and time, or the workstation this happened on.
>
> Does the logfile contain more information than what I have extracted?
>
> All I see is:
>
> --COMMIT-1022-0335664605
> COMMIT WORK
> go
> --BEGIN TRANSACTION-1022-0335664606
> BEGIN TRANSACTION
> go
> --DELETE-1022-0335664607
> DELETE FROM DBA.TABLES
> WHERE TABLEID='DISC'
> AND TABLENUM='50% Off Programs'
> go
>
>
> How can I find out more information like workstation name, process id,
> connnection name, date, time or anything more than this?
>
> Thank you.


Robert Paresi Posted on 2008-04-21 14:12:31.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
References: <480c9c4b$1@forums-1-dub> <480c9d4c@forums-1-dub>
In-Reply-To: <480c9d4c@forums-1-dub>
Subject: Re: Can I get more information from a LOGFILE?
Lines: 55
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <480ca0cf$1@forums-1-dub>
Date: 21 Apr 2008 07:12:31 -0700
X-Trace: forums-1-dub 1208787151 10.22.241.152 (21 Apr 2008 07:12:31 -0700)
X-Original-Trace: 21 Apr 2008 07:12:31 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6830
Article PK: 5067

Hello,

Can I turn on this while the db is in-use and running?

I did:

SET OPTION PUBLIC.AUDITING = 'ON'

But, I couldn't find anything in SCJVIEW on the DB or Engine level which
showed me this setting and verified that it was actually "ON" now.

-Robert

"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote in message
news:480c9d4c@forums-1-dub...
> Maybe if you enable auditing that will help out more in
> this case.
>
> Session-specific information is not tracked in the
> transaction log unless you enable auditing.
>
>
> "Robert Paresi" <FirstInitialLastName@innquest.com> wrote in message
> news:480c9c4b$1@forums-1-dub...
>> Hello,
>>
>> I've extracted a logfile, and see where the problem keeps happening at
>> the users site. However, now I need to know more information like the
>> exact date and time, or the workstation this happened on.
>>
>> Does the logfile contain more information than what I have extracted?
>>
>> All I see is:
>>
>> --COMMIT-1022-0335664605
>> COMMIT WORK
>> go
>> --BEGIN TRANSACTION-1022-0335664606
>> BEGIN TRANSACTION
>> go
>> --DELETE-1022-0335664607
>> DELETE FROM DBA.TABLES
>> WHERE TABLEID='DISC'
>> AND TABLENUM='50% Off Programs'
>> go
>>
>>
>> How can I find out more information like workstation name, process id,
>> connnection name, date, time or anything more than this?
>>
>> Thank you.
>
>


Robert Paresi Posted on 2008-04-21 14:15:12.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
References: <480c9c4b$1@forums-1-dub> <480c9d4c@forums-1-dub> <480ca0cf$1@forums-1-dub>
In-Reply-To: <480ca0cf$1@forums-1-dub>
Subject: Re: Can I get more information from a LOGFILE?
Lines: 70
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <480ca170$1@forums-1-dub>
Date: 21 Apr 2008 07:15:12 -0700
X-Trace: forums-1-dub 1208787312 10.22.241.152 (21 Apr 2008 07:15:12 -0700)
X-Original-Trace: 21 Apr 2008 07:15:12 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6831
Article PK: 5068

Hello,

I found it under Database Options.

But I like your idea on the trigger!!

Nice! I am going to do that now!

Thanks!

Robert

"Robert Paresi" <FirstInitialLastName@innquest.com> wrote in message
news:480ca0cf$1@forums-1-dub...
> Hello,
>
> Can I turn on this while the db is in-use and running?
>
> I did:
>
> SET OPTION PUBLIC.AUDITING = 'ON'
>
> But, I couldn't find anything in SCJVIEW on the DB or Engine level which
> showed me this setting and verified that it was actually "ON" now.
>
> -Robert
>
>
> "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote in message
> news:480c9d4c@forums-1-dub...
>> Maybe if you enable auditing that will help out more in
>> this case.
>>
>> Session-specific information is not tracked in the
>> transaction log unless you enable auditing.
>>
>>
>> "Robert Paresi" <FirstInitialLastName@innquest.com> wrote in message
>> news:480c9c4b$1@forums-1-dub...
>>> Hello,
>>>
>>> I've extracted a logfile, and see where the problem keeps happening at
>>> the users site. However, now I need to know more information like the
>>> exact date and time, or the workstation this happened on.
>>>
>>> Does the logfile contain more information than what I have extracted?
>>>
>>> All I see is:
>>>
>>> --COMMIT-1022-0335664605
>>> COMMIT WORK
>>> go
>>> --BEGIN TRANSACTION-1022-0335664606
>>> BEGIN TRANSACTION
>>> go
>>> --DELETE-1022-0335664607
>>> DELETE FROM DBA.TABLES
>>> WHERE TABLEID='DISC'
>>> AND TABLENUM='50% Off Programs'
>>> go
>>>
>>>
>>> How can I find out more information like workstation name, process id,
>>> connnection name, date, time or anything more than this?
>>>
>>> Thank you.
>>
>>
>


"Nick Elson" < Posted on 2008-04-21 14:05:38.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <480c9c4b$1@forums-1-dub>
Subject: Re: Can I get more information from a LOGFILE?
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <480c9f32$1@forums-1-dub>
Date: 21 Apr 2008 07:05:38 -0700
X-Trace: forums-1-dub 1208786738 10.22.241.152 (21 Apr 2008 07:05:38 -0700)
X-Original-Trace: 21 Apr 2008 07:05:38 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6829
Article PK: 5066

On second thought, since the only operation noted
is only on one single table you might be able to capture
the required info. via a trigger added to that table. In
that trigger you can easily could capture the entire
'appinfo' connection property string and log it into a
table; as well as with a message statement. That way
will permit your auditting the occurance both 'live'
and post-mortem.


HTH

"Robert Paresi" <FirstInitialLastName@innquest.com> wrote in message
news:480c9c4b$1@forums-1-dub...
> Hello,
>
> I've extracted a logfile, and see where the problem keeps happening at the
> users site. However, now I need to know more information like the exact
> date and time, or the workstation this happened on.
>
> Does the logfile contain more information than what I have extracted?
>
> All I see is:
>
> --COMMIT-1022-0335664605
> COMMIT WORK
> go
> --BEGIN TRANSACTION-1022-0335664606
> BEGIN TRANSACTION
> go
> --DELETE-1022-0335664607
> DELETE FROM DBA.TABLES
> WHERE TABLEID='DISC'
> AND TABLENUM='50% Off Programs'
> go
>
>
> How can I find out more information like workstation name, process id,
> connnection name, date, time or anything more than this?
>
> Thank you.