Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Feb 15 '12 at 13:00

This question came from our site for professional and enthusiast programmers.

1 Answer 1

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.

share|improve this answer
    
Thanks for the idea Graeme, but we're using the -hv flag so we can run as a service. Without the flag it works. I'm currently focused on trick 2 but logging isn't working when run as a service. –  invalidptr Feb 18 '12 at 3:20
    
That's odd, running as a service should not affect whether request level logging works. Could be a permission problem creating the reqlog.txt file. Note also that 9.0.2 is very old. The most recent version is 12.0.1. In understand that in some cases it's not possible to upgrade but if you can, you probably should. –  Graeme Perrow Feb 18 '12 at 13:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.