Trace field descriptions
A readable z/OS® data set is shipped with Db2 for z/OS that describes the individual fields of each IFCID. This data set is called prefix.SDSNIVPD(DSNWMSGS).
Some of the field descriptions in the prefix.SDSNIVPD(DSNWMSGS)
data set are marked with S
; that indicates that those fields
contain diagnosis, modification, and tuning information.
You can use the TSO or ISPF browse function to look at the field descriptions in prefix.SDSNIVPD(DSNWMSGS) 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.
Alternatively, you can choose to load the data set 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.