Samples
The parts for Record Trace File data are as follows.
Examples of CREATE TABLE and LOAD statements are in library RKO2SAMP. The description files are in a format that can be loaded into DB2 tables.
The CREATE TABLE examples can be used for building the DB2 tables into which Record Trace File data sets can be loaded. The DB2 load utility control statements can be used for loading these Record Trace File output records into DB2 tables.
| Type of data | CREATE TABLE statements | LOAD control statements | Sample query | Table description |
|---|---|---|---|---|
| Minibind (IFCID 22) | DGONCFMB | DGONLFMB | DGONQFMB | DGONBFMB |
| SQL Statement (IFCID 63) | DGONCFSQ | DGONLFSQ | DGONQFSQ | DGONBFSQ |
| SORT END (IFCID 96) | DGONCFSE | DGONLFSE | DGONQFSE | DGONBFSE |
| RID POOL (IFCID 125) | DGONCFRP | DGONLFRP | DGONQFRP | DGONBFRP |
| Deadlock (IFCID 172) | DGONCFDL | DGONLFDL | DGONQFDL | DGONBFDL |
| Timeout Data (IFCID 196) | DGONCFTI | DGONLFTI | DGONQFTI | DGONBFTI |
| SQL Statement Statistics (DYN SQL) (IFCID 316) | DGONCFDS | DGONLFDS | DGONQFDS | DGONBFDS |
| Dynamic Statement Acceleration (IFCID 316, section QW03162) | DGONCFD2 | DGONLFD2 | DGONBFD2 | |
| Remote Location Statistics (IFCID 365) | DGONCFRL | DGONLFRL | DGONQFRL | DGONBFRL |
| Static Statements in EDM Pool (STA SQL) (IFCID 401) | DGONCFSS | DGONLFSS | DGONQFSS | DGONBFSS |
| Static Statement Acceleration (IFCID 401, section QW04012) | DGONCFS2 | DGONLFS2 | DGONBFS2 |