Sybase IQ audit

Jan Franek
Jan Franek used Ask the Experts™
on
Is it possible to log all user activity in Sybase IQ server (like Sybase ASE auditing) ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015
Commented:
SET OPTION PUBLIC.AUDITING = 'ON'

actually with IQ you cannot enable/disable DB features from command line like run without auditing etc.

Author

Commented:
Thanks for the hint, but it seems like it does not record procedure calls and ad-hoc user queries. Can these actions be audited too ?
Top Expert 2015

Commented:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc74600.1270/html/iqrbaix/CIHGIBJC.htm

Some audit features are not available when it could hurt performance. Also given there is only few thousands of IQs around the world you should rely on Sybase documents, knowledge of ASE is just a shortcut there.

Author

Commented:
OK, I have found out, that auditing of procedure calls and ad-hoc queries is called request logging in Sybase IQ/SQL Anywhere. It can be switched on/off using command line options when starting the server (-zr -zs -zo) or using sa_server_option when the server is already running.
Top Expert 2015

Commented:
congratulations and thank you for feedback.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial