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.

Getting information about rollback only

2 posts in General Discussion Last posting was on 2008-04-07 21:59:24.0Z
Myron Oslie Posted on 2008-04-07 17:05:22.0Z
From: "Myron Oslie" <myrono@firstpac.com>
Newsgroups: ianywhere.public.general
Subject: Getting information about rollback only
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47fa5452@forums-1-dub>
Date: 7 Apr 2008 10:05:22 -0700
X-Trace: forums-1-dub 1207587922 10.22.241.152 (7 Apr 2008 10:05:22 -0700)
X-Original-Trace: 7 Apr 2008 10:05:22 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6803
Article PK: 5041

Is it possible to log rollbacks only? I have a situation where records are
'disappearing' without any evidence of them being there in the first place,
other than the user saying they were there and now they're gone. I would
like to avoid doing the full blown logging because this is an intermittent
situation (hoping anyway) and log files get to be somewhat large.

ASA 9.0.2

Thank you,
- Myron


"Nick Elson" < Posted on 2008-04-07 21:59:24.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <47fa5452@forums-1-dub>
Subject: Re: Getting information about rollback only
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47fa993c$1@forums-1-dub>
Date: 7 Apr 2008 14:59:24 -0700
X-Trace: forums-1-dub 1207605564 10.22.241.152 (7 Apr 2008 14:59:24 -0700)
X-Original-Trace: 7 Apr 2008 14:59:24 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6804
Article PK: 5042

Everything you need is already in the transaction log.

dbtran -a xxx.log [xxx.sql]

will include your rollbacks [along with everything else].
You can search on connection id [i.e. things that look like
'-1001-' in the output file], and if you know which objects
or connections to look for you can reduce the volumne
of output by filtering on table names (-it), logins (-u* / -x*),
time (-j <time>), or range in the transaction log (-ir *).

HTH

"Myron Oslie" <myrono@firstpac.com> wrote in message
news:47fa5452@forums-1-dub...
> Is it possible to log rollbacks only? I have a situation where records
> are 'disappearing' without any evidence of them being there in the first
> place, other than the user saying they were there and now they're gone. I
> would like to avoid doing the full blown logging because this is an
> intermittent situation (hoping anyway) and log files get to be somewhat
> large.
>
> ASA 9.0.2
>
> Thank you,
> - Myron
>