Enables request logging of operations.
{ dbeng12 | dbsrv12 } -zr { SQL | HOSTVARS | PLAN | PROCEDURES | TRIGGERS | OTHER | BLOCKS | REPLACE | ALL | NONE } ...
SQL enables logging of the following:
PLAN enables logging of execution plans (short form). Execution plans for procedures are also recorded if logging of procedures (PROCEDURES) is enabled.
HOSTVARS enables logging of host variable values. If you specify HOSTVARS, the information listed for SQL is also logged.
PROCEDURES enables logging of statements executed from within procedures.
TRIGGERS enables logging of statements executed from within triggers.
OTHER enables logging of additional request types not included by SQL, such as FETCH and PREFETCH. However, if you specify OTHER but do not specify SQL, it is the equivalent of specifying SQL+OTHER. Including OTHER can cause the log file to grow rapidly and could negatively affect server performance.
BLOCKS enables logging of details showing when a connection is blocked and unblocked on another connection.
REPLACE at the start of logging, the existing request log is replaced with a new (empty) one of the same name. Otherwise, the existing request log is opened and new entries are appended to the end of the file.
ALL logs all supported information. This setting is equivalent to specifying SQL+PLAN+HOSTVARS+PROCEDURES+TRIGGERS+OTHER+BLOCKS. This setting can cause the log file to grow rapidly and could negatively affect server performance.
NO or NONE turns off logging to the request log.
All operating systems and database servers.
This option should only be used when tracking problems. The information appears in the database server messages window or is sent to the request log. When you specify multiple values, they are separated with a , or a +.
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.
You can find the current value of the RequestLogging setting using the following query:
SELECT PROPERTY( 'RequestLogging' ); |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |