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.

Reading Log File

5 posts in General Discussion Last posting was on 2007-10-11 19:59:24.0Z
Herman Miller Posted on 2007-10-08 15:04:57.0Z
Sender: 7021.47067415.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Reading Log File
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470a4719.5717.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Oct 2007 08:04:57 -0700
X-Trace: forums-1-dub 1191855897 10.22.241.41 (8 Oct 2007 08:04:57 -0700)
X-Original-Trace: 8 Oct 2007 08:04:57 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6353
Article PK: 4719

I need to read the ASA Log file for entries on a specific
date and time. Isee there is a dbtran command with -j
parameter. Could someone help me on the syntax and an
example of how this would be used.

Rapid response appreciated.

Thanks


Breck Carter [Team iAnywhere] Posted on 2007-10-08 15:40:05.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Reading Log File
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <6ljkg3p83lv17aa7hm2q0mfusj5n0f4qqh@4ax.com>
References: <470a4719.5717.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 8 Oct 2007 08:40:05 -0700
X-Trace: forums-1-dub 1191858005 64.7.134.118 (8 Oct 2007 08:40:05 -0700)
X-Original-Trace: 8 Oct 2007 08:40:05 -0700, bcarter.sentex.ca
Lines: 25
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6355
Article PK: 2846

Here is an actual example, slightly edited for privacy, but not using
-j though:

"%ASANY9%\win32\dbtran.exe" -a -ir 021015000000,021030000000 -s -u uuu
-y xxx.log dbtran_xxx.sql
FIND /C /I "trigger" dbtran_xxx.sql
PAUSE

On 8 Oct 2007 08:04:57 -0700, Herman Miller wrote:

>I need to read the ASA Log file for entries on a specific
>date and time. Isee there is a dbtran command with -j
>parameter. Could someone help me on the syntax and an
>example of how this would be used.
>
>Rapid response appreciated.
>
>Thanks

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Herman Miller Posted on 2007-10-08 19:18:27.0Z
Sender: 7021.47067415.1804289383@sybase.com
From: herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Reading Log File
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470a8283.5bd8.1681692777@sybase.com>
References: <6ljkg3p83lv17aa7hm2q0mfusj5n0f4qqh@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Oct 2007 12:18:27 -0700
X-Trace: forums-1-dub 1191871107 10.22.241.41 (8 Oct 2007 12:18:27 -0700)
X-Original-Trace: 8 Oct 2007 12:18:27 -0700, 10.22.241.41
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6356
Article PK: 2849

What if I only have a date to check

> Here is an actual example, slightly edited for privacy,
> but not using -j though:
>
> "%ASANY9%\win32\dbtran.exe" -a -ir
> 021015000000,021030000000 -s -u uuu -y xxx.log
> dbtran_xxx.sql FIND /C /I "trigger" dbtran_xxx.sql
> PAUSE
>
> On 8 Oct 2007 08:04:57 -0700, Herman Miller wrote:
>
> >I need to read the ASA Log file for entries on a specific
> >date and time. Isee there is a dbtran command with -j
> >parameter. Could someone help me on the syntax and an
> >example of how this would be used.
> >
> >Rapid response appreciated.
> >
> >Thanks
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-10-10 17:42:01.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Reading Log File
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <qf3qg3h37nq8imkbsffdm62tesb4m8rco1@4ax.com>
References: <6ljkg3p83lv17aa7hm2q0mfusj5n0f4qqh@4ax.com> <470a8283.5bd8.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 10 Oct 2007 10:42:01 -0700
X-Trace: forums-1-dub 1192038121 64.7.134.118 (10 Oct 2007 10:42:01 -0700)
X-Original-Trace: 10 Oct 2007 10:42:01 -0700, bcarter.sentex.ca
Lines: 42
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6389
Article PK: 2866

You are going to have to try some experiments on your own, since
dbtran -j specifies a starting point, not a range.

On 8 Oct 2007 12:18:27 -0700, herman Miller wrote:

>What if I only have a date to check
>
>> Here is an actual example, slightly edited for privacy,
>> but not using -j though:
>>
>> "%ASANY9%\win32\dbtran.exe" -a -ir
>> 021015000000,021030000000 -s -u uuu -y xxx.log
>> dbtran_xxx.sql FIND /C /I "trigger" dbtran_xxx.sql
>> PAUSE
>>
>> On 8 Oct 2007 08:04:57 -0700, Herman Miller wrote:
>>
>> >I need to read the ASA Log file for entries on a specific
>> >date and time. Isee there is a dbtran command with -j
>> >parameter. Could someone help me on the syntax and an
>> >example of how this would be used.
>> >
>> >Rapid response appreciated.
>> >
>> >Thanks
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book:
>>
>http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Herman Posted on 2007-10-11 19:59:24.0Z
Sender: 3572.470e8016.1804289383@sybase.com
From: Herman
Newsgroups: ianywhere.public.general
Subject: Re: Reading Log File
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470e809c.3581.1681692777@sybase.com>
References: <6ljkg3p83lv17aa7hm2q0mfusj5n0f4qqh@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Oct 2007 12:59:24 -0700
X-Trace: forums-1-dub 1192132764 10.22.241.41 (11 Oct 2007 12:59:24 -0700)
X-Original-Trace: 11 Oct 2007 12:59:24 -0700, 10.22.241.41
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6412
Article PK: 4741

How can I check by date

> Here is an actual example, slightly edited for privacy,
> but not using -j though:
>
> "%ASANY9%\win32\dbtran.exe" -a -ir
> 021015000000,021030000000 -s -u uuu -y xxx.log
> dbtran_xxx.sql FIND /C /I "trigger" dbtran_xxx.sql
> PAUSE
>
> On 8 Oct 2007 08:04:57 -0700, Herman Miller wrote:
>
> >I need to read the ASA Log file for entries on a specific
> >date and time. Isee there is a dbtran command with -j
> >parameter. Could someone help me on the syntax and an
> >example of how this would be used.
> >
> >Rapid response appreciated.
> >
> >Thanks
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com