The Record Trace File Data Set and Output Records

The record trace file data set is a sequential data set of formatted records suitable for loading into the performance database using the Db2® load utility and from which reports can be produced using a reporting facility such as IBM® Query Management Facility (QMF).

The output of the FILE subcommand is a sequential variable blocked data set. The content of the output data set is determined by the FILE command options you specify, and by the input SMF/GTF records processed.

This data set contains SQL statement records and RID pool records.

Descriptions of the Record Trace File data sets and the fields contained can be found in the RKO2SAMP library under the following names:

DGONDFMB

For Minibind (IFCID 022) records

DGONDFSQ

For SQL Statement (IFCID 063) records

DGONDFSE

For Sort End (IFCID 096) records

DGONDFRP

For RID Pool (IFCID 125) records

DGONDFDL

For Deadlock (IFCID 172) records

DGONDFTI

For Timeout (IFCID 196) records

DGONDFDS

For Dynamic SQL Statement Statistics (IFCID 316) records

DGONDFRL

For Remote Location (IFCID 365) records

DGONDFIN

For Incompatibility (IFCID 376) records

DGONDFSS

For Static Statements in EDM Pool (IFCID 401) records