Activating Traces

You must activate the trace facility before you can generate traces.

Syntax: How to Activate the Trace Facility

You activate the tracing facility by issuing the following command at the command level, in a FOCEXEC, or in any FOCUS-supported profile:

SET TRACEUSER=ON

Syntax: How to Activate Trace Components

Activate specific traces prior to running the request for which you want the trace generated:

SET TRACEON = component / [level] / destination

where:

component

Is the component to activate. Components for the relational data adapters are:

SQLDI traces the SQL physical layer (formerly FSTRACE)

SQLAGGR provides optimization information (formerly FSTRACE3)

STMTRACE displays generated SQL statements (formerly FSTRACE4)

SQLCALL traces commands and data exchange between the physical and the logical layers of the data adapter.

level

If a component is associated with multiple levels, identifies the trace level to activate. Trace levels are not necessary for the relational components. You must indicate their absence with a double slash (//).

destination

Can be one of the following:

FSTRACE returns the trace output to the destination indicated in the allocation for DDNAME FSTRACE. You must explicitly allocate this DDNAME.

CLIENT displays the trace output on the screen of an online session. No explicit allocation is necessary.