Sybase SQL tracing

[Ahmad Munawwar]

Hi,

How to setup the sql tracing to monitor the ongoing process? What i mean is that, i got a script to remove expired and zero value for certain data in database table. I wated to see, what actually the script doing and where it stop when the error occurs.

For your infomation my sybase 11.0 is running on top of HP-UX 10.0.

Regards,
Munawwar

[Mark Seaman]

One way I have used to capture SQL is to use the Sybase auditing facility. You can capture the SQL for a single user or all users of a single database. There are lots of options and it does require setting up a separate database. Take a look at the sp_audit stored procedure and the Auditing chapter of the ASE System Administration Guide. To capture the SQL being executed, you need to turn on auditing of "cmdtext".

[Ahmad Munawwar]

Hi Mark,

Auditing facility is not install in my database. I will have a peoblem to install the facility as this required rebooting the database. Do you any suggestion?