Search code examples
sqlanywheresybase-asa

Sybase SQL Anywhere 10 - Logging SQL Statements


Does anyone know of a mechanism in Sybase ASA 9 / Sybase SQL Anywhere 10 to log the SQL statements that it executes?

I have a web application that is misbehaving due to some apparently missing data, but everything looks fine.

If we were able to log the offending statement we could probably get things sorted.


Solution

  • Take a look at the -zr server switch. You can also look at the sa_server_option system procedure to change the setting while the server is running.