Statistics tables

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

This figure is a graphical representation of the structure of the Statistics table. — Figure 1. The Statistics table

The generated table contains the following records:

General Data

File Data: One row for each Statistics delta record, containing data from IFCID 1 and 2.
A delta record is a set of counters that describes the DB2 activity between two consecutive DB2 Statistics record pairs.
Save-File Data: One row for each Statistics interval record, containing data from IFCID 1 and 2. A Statistics interval record is a set of counters that describes the DB2 activity within the interval specified by the user.

Buffer Pool Data

One row per buffer pool active at the start of the corresponding delta record for File data, or interval record for Save-File data (containing data from the QBST section of IFCID 2).

Group Buffer Pool Data

One row per group buffer pool active at the start of the corresponding delta record for File data, or interval record for Save-File data (containing data from the QBGL section of IFCID 2).

DDF

For each delta record (File data) or interval record (Save-File data), one row for all remote locations that used DRDA (containing data from the QLST section of IFCID 1).

Buffer Pool Data Set Data

One row for each open data set that has an I/O event rate at least one event per second during the reporting interval (containing data from IFCID 199).

Accelerator Data

One row per active accelerator attached to the DB2 subsystem (containing data from the Q8ST section of IFCID 2).

Aggregated Accounting Data

One row is written for a connection type IMS, CICS, RRSAF, Utility, Batch, or DDF containing aggregated wait and CPU times of threads with IFCID 3 events for that connection type (containing data from IFCID 369).

Storage Data

One row is written for DB2 storage metrics valid for the reporting interval (containing data from IFCID 225).

Simulated Buffer Pool Data

One row per simulated buffer pool active at the start of the corresponding delta record for File data, or interval record for Save-File data (containing data from the QBSP section of IFCID 2).