x

Activate specific trace components 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 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 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.

x

By default, a timestamp is prepended to each line of trace output. You can turn off the trace timestamps using the SET TRACESTAMP command.

SET TRACESTAMP = {ON|OFF|TLEFT}

where:

ON

Prepends a timestamp to each line of trace output. ON is the default value.

OFF

Omits the timestamp from the trace output.

TLEFT

Prepends a timestamp to each line of trace output. Includes microseconds in the timestamp.