DB2 Traces
DB2 traces record diagnostic information describing particular events within a DB2 subsystem. As DB2 operates, trace information is written to various destinations. This trace information can be read and analyzed to obtain information on subsystem and application performance.
DB2 provides six types of traces, and each describes information about the DB2 environment. These six types of traces are outlined in the following table:
| Trace | Started By | Description |
|---|---|---|
| Accounting | DSNZPARM or START TRACE command | Records performance information about the execution of DB2 application programs |
| Audit | DSNZPARM or START TRACE command | Provides information about DB2 DDL, security, utilities, and data modification |
| Global | DSNZPARM or START TRACE command | Provides information for the servicing of DB2 |
| Monitor | DSNZPARM or START TRACE command | Records data useful for online monitoring of the DB2 subsystem and DB2 application programs |
| Performance | START TRACE COMMAND | Collects detailed data about DB2 events, enabling database and performance analysts to pinpoint the causes of performance problems. |
| Statistics | DSNZPARM or START TRACE command | Records information regarding the DB2 subsystems use of resources. |