The instrumentation facility component of DB2® enables
you to use six types of traces. 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. The types
of traces are statistics, accounting, audit, performance, monitor,
and global.
- Statistics
- Describe the total work executed in DB2. This information is
not related to any specific end 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
end 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.

[[ Contents Previous Page | Next Page Index ]]