Controlling Db2 trace data collection

Db2 provides commands for controlling the collection of trace data.

Before you begin

To use the trace commands, you must have one of the following types of authority:

• SYSADM or SYSOPR authority
• Authorization to issue start and stop trace commands (the TRACE privilege)
• Authorization to issue the display trace command (the DISPLAY privilege)

About this task

For descriptions of the Db2 trace types, see Types of Db2 traces.

To control Db2 traces, use the following approaches:

• Issue the following trace commands for the action that you want to take:
  • -START TRACE command (Db2) invokes one or more different trace types.
  • -DISPLAY TRACE command (Db2) display the trace options that are in effect.
  • -STOP TRACE command (Db2) stops any trace that was started by either the START TRACE command or by a subsystem parameter setting when Db2 started.
  • -MODIFY TRACE command (Db2) changes the trace events (IFCIDs) that are being traced for a specified active trace.

  You can specify other parameters to further qualify the scope of a trace. You can trace specific events within a trace type, and events within specific Db2 plans, authorization IDs, resource manager IDs, and locations. You can also control the destination for the trace data.

• You can specify certain trace types and classes to start automatically when Db2 starts by setting the following subsystem parameters:
  • AUDIT TRACE field (AUDITST subsystem parameter) specifies whether to start the audit trace automatically when Db2 starts,and the audit trace classes to start.
  • SMF ACCOUNTING field (SMFACCT subsystem parameter) specifies whether to send accounting data to SMF automatically when Db2 starts, and the accounting trace classes to be sent.
  • SMF STATISTICS field (SMFSTAT subsystem parameter) specifies whether to send statistical data to SMF automatically when Db2 starts, and the trace classes to be sent.
  • MONITOR TRACE field (MON subsystem parameter) specifies whether to start the monitor trace automatically when Db2 starts, and the monitor trace classes to start.

  For more information about these and other subsystem parameters that control Db2 traces, see DSNTIPN: Tracing parameters panel.