Db2 trace

The Db2 instrumentation facility component (IFC) provides a trace facility that you can use to record Db2 data and events.

Begin program-specific programming interface information.With the IFC, however, analysis and reporting of the trace records must take place outside of Db2. You can use Tivoli® OMEGAMON® XE 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 Tivoli OMEGAMON XE 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.End program-specific programming interface information.