Previous Topic: Tracing CA Top Secret Option for DB2 Authorization CallsNext Topic: Product Releases and Maintenance


TRACE=ON|OFF|QUERY

The TRACE keyword is required with one of the following operands:

ON

Turns on diagnostic tracing.

OFF

Turns off diagnostic tracing.

QUERY

Produces a list of active traces.

TYPE=ALL|USER|JOB|CONNAME|CONTYPE

The TYPE keyword is required if you specify TRACE=ON|OFF, and must have one of the following operands:

ALL

The trace is for all threads.

USER

The trace is for a specific user(s).

JOB

The trace is for a specific job(s).

CONNAME

The trace is for a specific connection name(s).

CONTYPE

The trace is for a specific connection type(s).

SUBSYS=subsystemname

The SUBSYS= keyword is required, and has only one operand, subsystemname.

subsystemname

Indicates the explicit name of the DB2 subsystem CA Top Secret Option for DB2 is protecting for which you are requesting diagnostic trace messages. You cannot mask the subsystem name.

NAME=typename

The NAME keyword is required when you are also specifying the TYPE= keyword, and has only one operand, typename.

Typename

Indicates the name of the thread type to trace. You can specify the name with a mask as follows:

?—Matches any single character.

*—Matches all remaining characters, including null.

When you specify TYPE=USER, typename specifies the primary authorization ID to trace.

When you specify TYPE=JOB, typename specifies the name of a job to trace.

When you specify TYPE=CONNAME, typename specifies the connection name to trace (such as BATCH, TSO, DB2CALL). A connection name of SERVER is used for distributed calls when the remote system is not DB2.

When you specify TYPE=CONTYPE, typename specifies the connection type to trace (such as BATCH, DIST, MASS, SASS).

You can execute CADB2TRC multiple times to active multiple trace types. Each execution produces a list of all active trace requests. A request of TYPE=ALL,TRACE=OFF turns off all tracing requests. All output from CADB2TRC is written to the job log.