“-zr” to collect SQL statements - IQ switch - start option

July 16, 2009

-zr [ ALL | NONE ]
ALL logs all SQL statements and other requests to the server.
NONE turns off SQL statement logging. This is the default.

The -zr option can be used with IQ 12.6 and later to collect SQL statements into the .srvlog file in $SYBASE/logfiles. The option must be written into the config file with the qualifier all or sql, e.g. -zr all IQ also has the -zo switch/option to direct the output to another file and the -zs switch/option to limit the size of the output file.

NOTE: There are no messages when the IQ Server is started to show that the option has been implemented.

tags: ,
posted in asiq by Frank

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org