How do I dump the Sybase ASA error log?

The Sybase ASA engine has a series of database startup flags that enable logging and enable you to limit the size of the active log file. The following command uses the -zs flag to restrict the size of the active log to 10K. Once the log reaches 10K, the mydatabase.log file is renamed mydatabase.old, and a new mydatabase.log is created. (Any existing mydatabase.old file is overwritten.) This process is repeated in perpetuity.

dbeng9 -zr all -zs 10 -zo mydatabase.log


Consult the Adaptive Server Anywhere Database Administration Guide for additional information on Sybase ASA logging parameters.