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

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.

DBA authority

None

• Choosing a diagnostic tracing level
• Diagnostic tracing scopes
• sa_diagnostic_tracing_level table
• Advanced application profiling using diagnostic tracing

The following example sets the tracing level to 1. This means that the entire database will be profiled for performance counter data, and 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' );