Trace Activation and Deactivation Examples

The following commands activate the trace facility and make sure that only the traces we want are activated:

SET TRACEUSER = ON
SET TRACEOFF = ALL

The following command activates the SQLDI trace and displays the trace output on the terminal:

SET TRACEON = SQLDI//CLIENT

The following command activates the STMTRACE component and writes the trace output to the file allocated to DDNAME FSTRACE:

SET TRACEON = STMTRACE//FSTRACE

The following command turns off all traces allocated to DDNAME FSTRACE for all components:

SET TRACEOFF = //FSTRACE