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 - SQL Reference » System Procedures » System procedures

sa_set_soap_header system procedure Next Page

sa_set_tracing_level system procedure


Initializes the level of tracing information to be stored in the diagnostic tracing tables.

Syntax

sa_set_tracing_level(
level
[, specified_scope
, specified_name ]
[, do_commit ]
)

Arguments
Remarks

This procedure replaces the rows into the sa_diagnostic_tracing_level table, changing the tracing level and scope to the settings specified when calling the procedure.

Setting the level 0 does not stop the tracing session. Instead, the tracing session remains attached to the tracing database, but no tracing data is sent. The tracing session is still active when the level is 0.

This system procedure must be called from the database being profiled.

Permissions

DBA authority required

Side effects

None.

See also
Examples

The following example sets the tracing level to 1. This means that the entire database will be profiled for performance counter data, as well as some samples of executed statements:

CALL sa_set_tracing_level( 1 );

The following example sets the tracing level to 3, and specifies the user AG84756. This means that only activities associated with AG84756 will be traced:

CALL sa_set_tracing_level( 3, 'user', 'AG84756' );