DB2-supplied accounting and monitoring information

The instrumentation facility component of DB2® enables you to use six types of traces: statistics, accounting, audit, performance, monitor, and global. For each trace type, you can activate a number of trace classes.

You can use SMF as the trace output destination. Another alternative is to externalize the trace output under control of GTF.
Statistics
Describe the total work executed in DB2. This information is not related to any specific user. The main purposes of the DB2 statistics trace are to:
  • Supply data for DB2 capacity planning.
  • Assist with monitoring and tuning at the DB2 subsystem level.
  • Assist in accounting for DB2 activity.
The statistics records are written at user-defined intervals. You can reset the statistical collection interval and the origination time without stopping and starting the trace by using the MODIFY TRACE command. All DB2 activity for the statistical collection interval is reported in the record. This can make it difficult to directly relate the activity to specific users.

The DB2 statistics trace can be activated for several classes. If the statistics records are written to SMF, the SMF types are 100 and 102.

Accounting
Describes the work performed on behalf of a particular user (authorization ID from the DB2CONN or DB2ENTRY). The main purposes of the accounting records are to charge the DB2 cost to the authorization ID and perform monitoring and tuning at the program level. DB2 produces an accounting record at thread termination or when a transaction is reusing a thread with a new authorization ID. That means that if a thread is defined as protected (PROTECTNUM>0) and all transactions with the same transaction code for this DB2ENTRY use the same authorization ID, only one accounting record is produced, describing all activity done in the thread. Additionally, accounting records are written if you set ACCOUNTREC in your DB2ENTRY or DB2CONN definitions to UOW, TASK, or TXID. Setting ACCOUNTREC to these options is considered a signon, even if you use the same authorization ID.

You can activate the DB2 accounting trace for several classes. If the accounting records are written to SMF, the SMF type is 101 and 102.

Audit
Collects information about DB2 security controls and is used to ensure that data access is allowed only for authorized purposes. If the audit records are written to SMF, the SMF type is 102.
Performance
Records information for a number of different event classes. The information is intended for:
  • Program-related monitoring and tuning
  • Resource-related monitoring and tuning
  • User-related monitoring and tuning
  • System-related monitoring and tuning
  • Accounting-related profile creation

You can activate the DB2 performance trace for several classes. If the performance records are written to SMF, the SMF type is 102.

Monitor
Records data for online monitoring with user written programs
Global
Aids serviceability. If the global trace records are written to SMF, the SMF type is 102.