Diagnostic tracing settings are specific to a production database. You use the Database Tracing Wizard in Sybase Central to change diagnostic tracing settings when creating a tracing session. To learn how to start the Database Tracing Wizard, see Create a diagnostic tracing session.

Diagnostic tracing settings configured in the Database Tracing Wizard do not affect settings or behavior for the Application Profiling Wizard. The settings for the Application Profiling Wizard are preconfigured and cannot be changed.

You can also use the sa_set_tracing_level system procedure to change the diagnostic tracing level. This does not start a tracing session, and fails if a tracing session is already in progress. Also, it does not allow you as much control over other settings such as scopes, conditions, values, and so on. For more information about this procedure, see sa_set_tracing_level system procedure.

 To change the diagnostic tracing level (Interactive SQL)

 Example

CALL sa_set_tracing_level( 1 );