Accounting information provided by the Db2 accounting facility

The Db2® accounting facility provides detailed statistics on the use of Db2 resources by CICS® transactions. You can use Db2 accounting records as the basis for the accounting and tuning of Db2 resources used by CICS transactions.

Db2 gathers accounting data on an authorization ID within thread basis. When requested, the accounting facility collects this data and directs it to SMF, GTF, or both when the thread is terminated or when the authorization ID is changed. For information about activating the Db2 accounting facility and directing the output to SMF and GTF, see Obtaining Db2 accounting, statistics, monitoring, and performance data. See Managing Db2 performance in Db2 for z/OS product documentation for information on the general structure of Db2 SMF and GTF records.

The identification section of each Db2 accounting record written to SMF and GTF provides a number of keys on which the data can be sorted and summarized. These include the authorization ID, the transaction ID, the plan name, and the package name.

The Db2 Performance Monitor (DB2PM) licensed program provides accounting reports taken from the Db2 accounting records.