Db2 trace codes

A readable z/OS® data set is shipped with Db2, which describes the Db2 trace codes that are issued by the global trace facility. These trace codes are known as event identifiers (EIDs). The data set is called prefix.SDSNSAMP(DSNWEIDS).

Use the TSO or ISPF browse function to look at these descriptions online, even when Db2 is down. To look at the descriptions in printed form, use ISPF to print a listing of the data set.

Alternatively, the data set can be loaded into a user-defined Db2 table. This approach has the advantage of providing access to the EID descriptions through SQL SELECT statements in whatever order or format required. SQL can also be used to tailor the information before you print it.

Maintaining EID descriptions

Periodically, updated data is included on Db2 corrective service tapes. These tapes are shipped with the ++HOLD statement, with instructions to replace the original data set with the updated data set. In this way, the EID descriptions are kept current with Db2 code.