Db2 trace
The Db2 instrumentation facility component (IFC) provides a trace facility that you can use to record Db2 data and events.
With the IFC, however, analysis
and reporting of the trace records must take place outside of Db2. You
can use IBM® OMEGAMON® for Db2 Performance Expert on z/OS® to
format, print, and interpret Db2 trace
output. You can view an online snapshot from trace records by using IBM OMEGAMON for Db2 Performance Expert on z/OS or
other online monitors.
Each trace class captures information on several subsystem events. These events are identified by many instrumentation facility component identifiers (IFCIDs). The IFCIDs are described by the comments in their mapping macros, contained in prefix.SDSNMACS, which is shipped to you with Db2.
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 find descriptions of trace records in the IFCID flat file (DSNWMSGS). The most current version of DSNWMSGS is available only for clients who have Db2 13 for z/OS licenses. The information is in a PDF file. To locate this information, see Db2 13 for z/OS IFCID flat file (DSNWMSGS).
