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.

Do you know logdigger?

2 posts in General Discussion Last posting was on 2010-01-16 19:06:14.0Z
james Posted on 2009-11-05 06:31:54.0Z
From: james <hobbylu@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Do you know logdigger?
Date: Wed, 4 Nov 2009 22:31:54 -0800 (PST)
Organization: http://groups.google.com
Lines: 60
Message-ID: <77c5a00c-eddd-4f96-934b-71a41ff28c29@g22g2000prf.googlegroups.com>
NNTP-Posting-Host: 222.44.33.189
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1257402714 720 127.0.0.1 (5 Nov 2009 06:31:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 Nov 2009 06:31:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g22g2000prf.googlegroups.com; posting-host=222.44.33.189; posting-account=lLJJXAoAAAB5c3kS_iuETkFHUOu286BD
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.1.4322; CIBA; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; TheWorld),gzip(gfe),gzip(gfe)
X-Original-Bytes: 3795
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g22g2000prf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28610
Article PK: 77862

LogDigger

LogDigger(tm) is a powerful tool for Sybase ASE serials databases,
allowing administrators to easily locate changes in the database,
enabling sophisticated data analyses, and providing undo capabilities
to rollback logical data corruptions or user errors.
syslogs stores all operation records which modify database. Sybase
does not provide tool to read and anlyse syslogs. Sometime DBA want to
know what stored in the syslogs, like operate record to a table, to a
transaction etc. It presents xactid,op columns when we query on
syslogs table, which can't be read. Senior dba can use dbcc log to get
details, but dbcc log command is difficult to master and the result
also not easy to read. So LogDigger filled the blank of syslogs
translater.
LogDigger can also be leveraged for:
* Ex post facto auditing of DML statements, the order in which
transactions were committed and the user responsible for the updates.
* Historical analysis of data access patterns for database tuning and
capacity planning.
LogDigger directly accesses the Sybase redo logs, which are complete
records of all activities performed on the database, and the
associated data dictionary, which is used to translate internal object
identifiers and types to external names and data formats. Each row
contains a SQL UNDO statement, which can be used to rollback the
change, and SQL REDO statement, which details the original operation.
LogDigger can translate to a flat file.
Installation
1 To use LogDigger, please install Sybase client of pre 12.5.4.
2 Download newest version from http://www.sybedit.com, and extract to
a folder.

How to use LogDigger

1、Double click on LogDigger
2、Click ConnectDB Button

3、Input login name, password, and ASE server name

then click OK button to login, click Cancel button to exit.

4、Please select the database to be anlysed, default db is master。默认登陆数据
库为master

5、Click Setting button,set the option
6、Click ReadLog button

7、Click TranLog button,to translate syslogs


Looking to the Future
LogDigger is developed by vs2005, dbcc log command is the point. In
the future, with more function, it will be replication server, like
ase Replicator, replication server. But it's so far to do. LogDigger
can be a tool to monitor syslogs, record all the operation to a file.
The function is simple of LogDigge, more function, more supported
database version are necessary.


andkylee Posted on 2010-01-16 19:06:14.0Z
From: "andkylee" <andkylee@gmail.com>
Newsgroups: sybase.public.ase.general
References: <77c5a00c-eddd-4f96-934b-71a41ff28c29@g22g2000prf.googlegroups.com>
Subject: Re: Do you know logdigger?
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b520e26@forums-1-dub>
Date: 16 Jan 2010 11:06:14 -0800
X-Trace: forums-1-dub 1263668774 10.22.241.152 (16 Jan 2010 11:06:14 -0800)
X-Original-Trace: 16 Jan 2010 11:06:14 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28886
Article PK: 78128

i had installed your this tool,indeed a nice thing.can we get the logs from
ASE15.0 using your LogDigger(tm) ?
thanks!

"james" <hobbylu@gmail.com> дÈëÏûÏ¢ÐÂÎÅ:77c5a00c-eddd-4f96-934b-71a41ff28c29@g22g2000prf.googlegroups.com...
LogDigger

LogDigger(tm) is a powerful tool for Sybase ASE serials databases,
allowing administrators to easily locate changes in the database,
enabling sophisticated data analyses, and providing undo capabilities
to rollback logical data corruptions or user errors.
syslogs stores all operation records which modify database. Sybase
does not provide tool to read and anlyse syslogs. Sometime DBA want to
know what stored in the syslogs, like operate record to a table, to a
transaction etc. It presents xactid,op columns when we query on
syslogs table, which can't be read. Senior dba can use dbcc log to get
details, but dbcc log command is difficult to master and the result
also not easy to read. So LogDigger filled the blank of syslogs
translater.
LogDigger can also be leveraged for:
* Ex post facto auditing of DML statements, the order in which
transactions were committed and the user responsible for the updates.
* Historical analysis of data access patterns for database tuning and
capacity planning.
LogDigger directly accesses the Sybase redo logs, which are complete
records of all activities performed on the database, and the
associated data dictionary, which is used to translate internal object
identifiers and types to external names and data formats. Each row
contains a SQL UNDO statement, which can be used to rollback the
change, and SQL REDO statement, which details the original operation.
LogDigger can translate to a flat file.
Installation
1 To use LogDigger, please install Sybase client of pre 12.5.4.
2 Download newest version from http://www.sybedit.com, and extract to
a folder.

How to use LogDigger

1¡¢Double click on LogDigger
2¡¢Click ConnectDB Button

3¡¢Input login name, password, and ASE server name

then click OK button to login, click Cancel button to exit.

4¡¢Please select the database to be anlysed£¬ default db is master¡£Ä¬ÈϵǽÊý¾Ý
¿âΪmaster

5¡¢Click Setting button£¬set the option
6¡¢Click ReadLog button

7¡¢Click TranLog button£¬to translate syslogs


Looking to the Future
LogDigger is developed by vs2005, dbcc log command is the point. In
the future, with more function, it will be replication server, like
ase Replicator, replication server. But it's so far to do. LogDigger
can be a tool to monitor syslogs, record all the operation to a file.
The function is simple of LogDigge, more function, more supported
database version are necessary.