Tracing/Logging of Sybase ASA

sybase

Trying to get logging/tracing of Sybase 9.0.2.3396 (Adaptive Server Anywhere). I wish to log all the SQL executed against the database.

I tried RIBO and while I got it "working," I never saw anything captured. Port 5003 for listen, server: localhost, and Server Port 2638.

I also tried ODBC tracing on WinXP but with limited success. I got some "connection information" but never any actual transaction tracing.

Best Answer

Take a look at the -zr switch on the server, which turns on "request level logging". Start the server with -zr all -zo reqlog.txt and then look at reqlog.txt after some queries have been executed. It's fairly verbose but should list the SQL that's being executed.

Disclaimer: I work for Sybase in SQL Anywhere engineering.

Related Solutions

Where clause short circuit? (sybase)

Generally, SQL is declarative. That is, you say "what you want" not "how to do it". One consequence of this is that you don't control what order things are processed or evaluated in at the same logical processing step (WHERE clause or GROUP BY clause etc are these steps)

That is, SQL doesn't generally short circuit because the concept doesn't apply.

There are several cases where it does (SQL Server and CASE for example) of course, but in your example you'd need the 2nd option to guarantee it. Note SQL Server has an optimisation for this kind of query but I'd assume Sybase doesn't

Parameter for Sybase Sql Anywhere 12 Serverport

The proper syntax is:

dbsrv12.exe -z -x tcpip(ServerPort=54382)

No space between tcpip and the (. You can use "Port=" instead of "ServerPort=" if you want.

Best Answer

Related Solutions

Where clause short circuit? (sybase)

Parameter for Sybase Sql Anywhere 12 Serverport

Related Question