Trace field descriptions
You can find descriptions of trace records in prefix.SDSNIVPD(DSNWMSGS).
A Db2 trace
record consists of a number of trace fields. Each trace record has
an associated instrumentation facility component ID (IFCID), and each
trace field has a unique name. The DSNWMSGS file contains a list of
the trace records, ordered by IFCID, and a description of each field
within a trace record. The DSNWMSGS file includes instructions for
creating a table into which you can load its contents. After you load
the data, you can use SQL queries to search for specific IFCIDs and
descriptions of their contents. You can also use SQL queries to retrieve
summaries of trace types, classes, and associated IFCIDs.
If you intend to write a program to read Db2 trace records, use the assembler mapping macros in prefix.SDSNMACS. The macros have member names that begin with DSNDQW.
You can use the TSO or ISPF browse function to look at
the field descriptions in the trace record mapping macros online,
even when Db2 is
down. If you prefer to look at the descriptions in printed form, you
can use ISPF to print a listing of the data set.