Hi,

I'm trying to see the sql transactions submitted to sybase server. Is it
possible ? Is there any tool for that ?


Laurent

"Laurent RUHLMANN" <lruhlmann (AT) ingesoft (DOT) fr> wrote

You can use the auditing feature to audit all "cmdtext"
language sent to ASE. That would cover most sql transactions.

There are a lot more options if you upgrade to the current 12.5.1
version.

-bret

In jConnect (jdbc stuff) there's a sample program called 'ribo'. This
acts as a proxy that will show you the sql that's being sent to the server.

Jeff...

Laurent RUHLMANN wrote:

Jeffrey Voight <jeff_NO (AT) SPAM_cscc (DOT) net> wrote

There are numerous 3rd-party products on the market that can do this.
Try this, for example:
http://www3.ca.com/Solutions/Product.asp?ID=2816
(Never used it myself, so no guarantee)

Some years ago, I did use a product called LogAnalyzer by Platinum
Technology, which had a number of good features (offline DBCC checks,
generation of undo scripts to reverse transactions, auditing of
database changes etc), but I'm not sure if it's still available or
not.

If the transaction is currently running , you could use the
undocumented and unsupported dbcc pss command (you will need
sybase_ts_role enabled and use dbcc traceon(3604).

later versions of Sybase 11.9.2+ can use dbcc sqltext(spid).

Steve
On Thu, 12 Feb 2004 10:53:34 +0100, "Laurent RUHLMANN"
<lruhlmann (AT) ingesoft (DOT) fr> wrote: