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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|