sa_save_trace_data( )

While a tracing session is running, diagnostic data is stored in temporary versions of the diagnostic tracing tables. When you stop a tracing session, you specify whether you want to permanently store the tracing data in the base tables for diagnostic tracing. If you do not choose to save the data, you can still save the data after the session is stopped by using the sa_save_trace_data system procedure.

The sa_save_trace_data system procedure returns an error if tracing is still in progress; you must stop tracing to use this system procedure.

The sa_save_trace_data system procedure can be used even if the user specified WITHOUT SAVING when stopping tracing. Also, the procedure must be called from the tracing database.

You must have the MANAGE PROFILING system privilege.

Automatic commit.

• Creating a diagnostic tracing session (Sybase Central)
• Diagnostic tracing tables

This example saves tracing data to the diagnostic tracing tables.

CALL sa_save_trace_data( );