Record Trace tables

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

Figure 1. The Record Trace data set
This figure is a graphical representation of the structure of the Record Trace data set.
The generated data set contains the following records:
Access path
Minibind data. One row per IFCID 22.
SQL Statement
One row per SQL statement text record (IFCID 63).
SORT END
One row for each sort end event triggered by an SQL query (IFCID 96).
RID Pool
One row per multiple index access operation (IFCID 125).
Deadlock (Unit of Work)
One row per resource involved (IFCID 172).
Timeout Data
One row per agent causing the timeout (IFCID 196).
SQL Statement Statistics (DYN SQL)
One row per SQL statement statistics text record (IFCID 316).
Acceleration
One row per accelerator to which the statement has been offloaded (IFCID 316, section QW03162).
Remote Location Statistics
One row per remote location (IFCID 365).
Static Statements in EDM Pool (STA SQL)
One row per static statements text record in the EDM pool (IFCID 401).
Acceleration
One row per accelerator to which the statement has been offloaded (IFCID 401, section QW04012).