1

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.

Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
Andy Neillans
  • 258
  • 1
  • 2
  • 16

1 Answers1

3

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.

Graeme Perrow
  • 56,086
  • 21
  • 82
  • 121