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

This procedure replaces the rows in the sa_diagnostic_tracing_level table, changing the tracing level and scope to the settings specified when the procedure is called.

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.

You must have the DIAGNOSTICS system role, and the MANAGE PROFILING system privilege.

None

• Customized diagnostic tracing levels
• Diagnostic tracing scopes
• sa_diagnostic_tracing_level table
• Diagnostic tracing

The following example sets the tracing level to 1. The entire database is 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. Only activities associated with AG84756 are traced:

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