Trace field descriptions

You can find descriptions of trace records in prefix.SDSNIVPD(DSNWMSGS).

Begin program-specific programming interface information.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. End program-specific programming interface information.