Explain the way to audit the SQL sent to the server

Question

Explain the way to audit the SQL sent to the server.

Answer 1

This does not appear to be well documented; therefore here is a quick means of auditing the SQL text which is sent to the server. Note that it simply audits the SQL sent to the server. Therefore, if your user process executes a big stored procedure, all you will observe here is a call to the stored procedure. No one of the SQL which is executed as part of the stored procedure will be listed.

Initially, you need to have installed Sybase security (that involves installing the sybsecurity database and loading this using the script as $SYBASE/scripts/installsecurity). And read the Sybase Security Administration Manual, you may wish for to enable a threshold procedure to toggle between couples of audit tables. Be aware, that the default configuration option "delay auditing when device full”, which is set to 1. It means that the server will suspend all normal SQL operations when the audit database becomes full and the so logs in and gets rid of several data. You might want to seem changing it to 0 unless yours is a above all sensitive installation.