Displaying global trace activity
The -DISPLAY TRACE command displays information about the traces that were started, including the options in effect.
In a data sharing group, you can enter the DISPLAY TRACE command on each subsystem that you want to monitor, or you can enter the command with the SCOPE(GROUP) option on one subsystem to cause Db2 to issue the command on all members of the data sharing group. The command output from all members goes to the console from which the -DISPLAY TRACE command was issued.
Because other traces can be started and stopped while you view -DISPLAY TRACE output, the information presented by the -DISPLAY TRACE command might change immediately after the display is complete.
Each -DISPLAY TRACE option, except TNO, limits the effect of the command to active traces that were started using the same option, either explicitly or by default, with exactly the same parameter values.
For example, the following command lists only the active traces that were started using the options GLOBAL and CLASS(1,2); it does not list, for example, any trace started using CLASS(1).
-DISPLAY TRACE (GLOBAL) CLASS (1,2)
Information about a particular trace can be displayed by specifying its trace number. For example, the following command displays the second trace that you invoked.
-DISPLAY TRACE TNO(2)
When a trace number is specified, you do not need to specify any other keywords or parameters. The trace number provides a sufficient level of detail for Db2 to stop or display trace activity.