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 Server - Database Administration » The Database Server » The SQL Anywhere database server » Database server options

-zp server option Next Page

-zr server option

Enables request logging of operations.


{ dbsrv10 | dbeng10 } -zr { SQL | HOSTVARS | PLAN | PROCEDURES | TRIGGERS | OTHER | BLOCKS | REPLACE | ALL | YES | NONE | NO } ...

Applies to

All operating systems and servers.


This should only be used when tracking problems. The information appears in the Server Messages window or is sent to the logging file.

The values for -zr return the following types of information:

Once the database server is started, you can change the request log settings to log more or less information using the sa_server_option system procedure. See sa_server_option system procedure.

You can find the current value of the RequestLogging setting using the following query:

SELECT PROPERTY( 'RequestLogging' )

RequestLogMaxSize    The maximum size of the file used to record request logging information, in bytes. If you 0, then there is no maximum size for the request logging file, and the file is never renamed. This is the default value.

When the request log file reaches the size specified by either the sa_server_option system procedure or the -zs server option, the file is renamed with the extension .old appended (replacing an existing file with the same name if one exists). The request log file is then restarted. See -zs server option.

RequestLogNumFiles    The number of request log file copies to retain.

If request logging is enabled over a long period of time, the request log file can become large. The -zn option allows you to specify the number of request log file copies to retain. See -zn server option.

RequestTiming    Instructs the database server to maintain timing information for each request. This feature is turned off by default. You can use the sa_performance_diagnostics procedure to obtain a summary of the request timing information. See -zt server option, and sa_performance_diagnostics system procedure.

SecureFeatures    Specifies features that are disabled for databases running on this database server. The feature-list is a comma-separated list of feature names or feature sets. For a list of valid feature-list values, see -sf server option.

See also