|
You can set the following options for the SQL Anywhere 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 logging Select this option to record requests that the server processes to the log file. This option is primarily for troubleshooting purposes.
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.
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 data_format option setting for the database. You can view the current setting of the date_format option with the following query:
SELECT CONNECTION_PROPERTY ( 'date_format' )
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. You can click Browse to locate a file to which server messages are logged.