SQL Anywhere Studio Help
Console Utility Help
Options dialog
You can set the following options for the Console utility:
Disable new connections Select this option to prevent other users from connecting to the database. The may be useful for some maintenance operations.
Enable request-level logging Select this option to record requests that the server processes to the log file. This option is primarily for troubleshooting purposes.
For more information, see -zr server option.
Remember last statement Select this option to instruct the database server to capture the most recently-prepared SQL statement for each connection to databases on the server. For stored procedure calls, only the outermost procedure call appears, not the statements within the procedure.
For more information, see -zl server option.
Idle client shutdown time Select this option to disconnect connections that have not submitted a request for the amount of time specified in the adjacent field. By default, this value is 120 seconds.
Quitting time You can type a time when the database server is to shut down. Use the same format as the current time, which is as follows:
YYYY-MM-DD HH:NN:SS.SS
Current time Displays the current time.
Log messages to file Select this option to log server messages to a file that you specify in the field below.
Browse Click Browse to locate a file to which server messages are logged.
sa_server_option system procedure