Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Console Utility Help

Using the SQL Anywhere Console utility Next Page

Console options

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:


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.

See also