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.
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 database 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.
Enable request logging Select this option to record requests that the database server processes to the request log. You can customize the request logging once this option has been enabled. This option is primarily for troubleshooting purposes. See -zr database server option.
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 database 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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|