Trace field descriptions
You can find descriptions of trace records in the IFCID flat file (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.
IFCID numbers are often presented in Db2 and its documentation with three or four digits and leading zeros. For example, you might find: "IFCID 1," "IFCID 001," or "IFCID 0001." However, you can assume that these references each have the same meaning.
You can load the DSNWMSGS file into a user-defined Db2 table. This approach has the advantage of providing you with access to the IFCID field descriptions through SQL SELECT statements in whatever order or format you choose. You can also use the power of SQL to tailor the information to meet the needs at your site before you print it. Because of the wide variation from customer to customer in how Db2 trace data is analyzed, you might find this method most convenient. DSNWMSGS contains sample SQL statements for creating a user-defined Db2 table and retrieving information from it, as well as LOAD utility control statements for populating the table.
- The most current version of DSNWMSGS is available only for clients who have Db2 12 for z/OS® licenses. The information is in a PDF file. To locate this information, see Db2 12 for z/OS IFCID flat file (DSNWMSGS).
- An older version of DSNWMSGS is available in the prefix.SDSNIVPD(DSNWMSGS) data set. You can use the TSO or ISPF browse function to look at the field descriptions in prefix.SDSNIVPD(DSNWMSGS), 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.
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.
