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

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere Console utility help


Options window: Console tab

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. This option may be useful for some maintenance operations.

Enable request logging   Select this option to record requests that the database server processes to the request log. This option is primarily for troubleshooting purposes. See -zr dbeng12/dbsrv12 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 running on the database server. For stored procedure calls, only the outermost procedure call appears, not the statements within the procedure. See -zl dbeng12/dbsrv12 server option.

Idle client shutdown time (seconds)   Specify the amount of time, in seconds, after the last request from a client before the SQL Anywhere Console utility disconnects the connection. The default is 120 seconds.

Quitting time   Select this option to specify a date and time when the database server is to shut down. Click the Calendar button to browse for the date. Specify the time in the adjacent field. See -tq dbeng12/dbsrv12 server option.

Log messages to file   Select this option to log database server messages to the database server messages log file that you specify in the field below. You can click Browse to locate a file.

 See also