Accounting tables

This section shows the structure of each of the Accounting tables in the performance database.

Figure 1. The Accounting tables
This figure is a graphical representation of the structure of the Accounting tables.
The generated data set consists of the following records:
General
One row per thread.
Group buffer pool
One row per group buffer pool used.
Package data
One row per package and DBRM executed.
DDF data
One row per remote location participating in distributed activity.
Buffer pool data
One row per buffer pool used.
RLF
One row per resource limit type encountered.
Accelerator data
One row per thread-related accelerator activity.
Buffer Pool Totals
  • One row per buffer pool size, showing a summary of all active buffer pools of that size. Note that, the total records are created only if at least one buffer pool of that size is active.
  • One row showing the overall total of all buffer pools.
Group Buffer Pool Totals
  • One row per group buffer pool size, showing a summary of all active group buffer pools of that size. Note that, the group total records are created only if at least one group buffer pool of that size is active.
  • One row showing the overall total of all group buffer pools.

When parallel tasks are performed within a data sharing group, the parallel task records are contained in the record of the originating task, regardless of whether the parallel tasks were performed on the same member as the originating task or on other members of the data sharing group.