The following commands activate the trace facility to the screen, make sure that only the trace components we want are activated, and activates the SQLDI trace component to the screen:

SET TRACEUSER = ON
SET TRACEOFF = ALL
SET TRACEON = SQLDI//CLIENT

The following command activates the STMTRACE component and writes the trace output to the file allocated to DDNAME FSTRACE. Note that the SET TRACEUSER=FSTRACE command is issued after all trace components are activated:

SET TRACEOFF = ALL
SET TRACEON = STMTRACE//FSTRACE
SET TRACEUSER = FSTRACE

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

SET TRACEOFF = //FSTRACE