I have a -o parameter on dbsrv9.exe.. that spins the console log to a text file.
The file gets pretty big over time, and I'd like to start a new log file every couple days or so.
Is there a way to do that?
I'm running 220.127.116.1150
asked 10 Jun '10, 18:11
If you simply want to keep the console log file at a reasonable size and have the server automatically start a new file when it reaches a certain size then using the -os command line option is a solution (as pointed out by Zote). This is the only solution available in SA 9 if the server is not to be restarted.
Starting in SQL Anywhere 10, you can also change the console log file by using the SQL statement:
This statement starts a new console log file named 'new-file-name.txt'. Setting the value to '' (empty string) turns off recording the console messages to file.
A similar option - 'ConsoleLogMaxSize' - may be used (starting in v10) to set the size at which a new log file is automatically started.
answered 10 Jun '10, 21:49
use -os option
See more in SA help at
answered 10 Jun '10, 20:13