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.

Analyze a dump tran log

5 posts in Backup and Recovery Last posting was on 2010-10-28 13:57:44.0Z
jbourst Posted on 2010-10-25 14:44:28.0Z
Sender: 2e97.4cc596c2.1804289383@sybase.com
From: Jbourst
Newsgroups: sybase.public.ase.backup+recovery
Subject: Analyze a dump tran log
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cc597cc.2eab.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Oct 2010 07:44:28 -0700
X-Trace: forums-1-dub 1288017868 10.22.241.41 (25 Oct 2010 07:44:28 -0700)
X-Original-Trace: 25 Oct 2010 07:44:28 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4126
Article PK: 48208

Hi
Sybase 15.0.3..
Is it possible to analyse the tran log not active (dump
tran..)
With Sybase 10 and sybase we had a Log Analyser Platinium..
But this product is not any more distributed.
Have you a solution, a product ??

regards


Bret Halford Posted on 2010-10-25 15:03:00.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.11) Gecko/20101013 Thunderbird/3.1.5
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: Analyze a dump tran log
References: <4cc597cc.2eab.1681692777@sybase.com>
In-Reply-To: <4cc597cc.2eab.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: <4cc59c24@forums-1-dub>
Date: 25 Oct 2010 08:03:00 -0700
X-Trace: forums-1-dub 1288018980 10.22.241.152 (25 Oct 2010 08:03:00 -0700)
X-Original-Trace: 25 Oct 2010 08:03:00 -0700, vip152.sybase.com
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4127
Article PK: 48215


On 10/25/2010 8:44 AM, Jbourst wrote:
> Hi
> Sybase 15.0.3..
> Is it possible to analyse the tran log not active (dump
> tran..)
> With Sybase 10 and sybase we had a Log Analyser Platinium..
> But this product is not any more distributed.
> Have you a solution, a product ??
>
> regards

What analysis do you have in mind?


jbourst Posted on 2010-10-27 10:42:36.0Z
Sender: 6493.4cc7ff7d.1804289383@sybase.com
From: jbourst
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: Analyze a dump tran log
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cc8021c.6503.1681692777@sybase.com>
References: <4cc59c24@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Oct 2010 03:42:36 -0700
X-Trace: forums-1-dub 1288176156 10.22.241.41 (27 Oct 2010 03:42:36 -0700)
X-Original-Trace: 27 Oct 2010 03:42:36 -0700, 10.22.241.41
Lines: 40
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4128
Article PK: 48217


> On 10/25/2010 8:44 AM, Jbourst wrote:
> > Hi
> > Sybase 15.0.3..
> > Is it possible to analyse the tran log not active (dump
> > tran..)
> > With Sybase 10 and sybase we had a Log Analyser
> > Platinium.. But this product is not any more
> > distributed. Have you a solution, a product ??
> >
> > regards
>
>
> What analysis do you have in mind?
>
>

HI
An user deleted some records in a specific table.
So with this analyze i should like to know with which tool
this user has deleted these records ? (with spid)

But know i abandonned this research. i use dataserver -X
-Pquine
. (sybmon)
with dbcclog i load my dump transaction.
but how can i found the deletes for a specific table.

with dbcclog

ééééé
log on trace_prd_GPF-20101022-170936.tlg.LST
DBCCLOG command> table 2108531514
LOG SCAN DEFINTION:
Forward scan: starting at begining of log
log records for object id 2108531514

LOG RECORDS:
éééé
but nothing answer...

Thanks