Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase SQL tracing

Ahmad Munawwar
Frequent Advisor

Sybase SQL tracing

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
2 REPLIES
Mark Seaman
Advisor

Re: Sybase SQL tracing

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
Frequent Advisor

Re: Sybase SQL tracing

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?