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.

Transaction log viewer for ASE 15?

2 posts in General Discussion Last posting was on 2011-09-19 06:31:47.0Z
A M Posted on 2011-09-13 23:42:02.0Z
Sender: 4fa0.4e6fe88f.1804289383@sybase.com
From: A M
Newsgroups: sybase.public.ase.general
Subject: Transaction log viewer for ASE 15?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e6fea4a.5043.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Sep 2011 16:42:02 -0700
X-Trace: forums-1-dub 1315957322 10.22.241.41 (13 Sep 2011 16:42:02 -0700)
X-Original-Trace: 13 Sep 2011 16:42:02 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30536
Article PK: 72716

Hi,

Is thre anything available to read Sybase 15 transaction
log? Free or not? We're trying to solve one mystery data
disappearance.

TIA


Rob V Posted on 2011-09-19 06:31:47.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Transaction log viewer for ASE 15?
References: <4e6fea4a.5043.1681692777@sybase.com>
In-Reply-To: <4e6fea4a.5043.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e76e1d3@forums-1-dub>
Date: 18 Sep 2011 23:31:47 -0700
X-Trace: forums-1-dub 1316413907 10.22.241.152 (18 Sep 2011 23:31:47 -0700)
X-Original-Trace: 18 Sep 2011 23:31:47 -0700, vip152.sybase.com
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30543
Article PK: 72719


On 14-Sep-2011 01:42, A M wrote:
> Hi,
>
> Is thre anything available to read Sybase 15 transaction
> log? Free or not? We're trying to solve one mystery data
> disappearance.
>
> TIA

You can use the 'dbcc log' command to dig through the log. THis is
'free' as it is part of any ASE installation.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------