Application Trace Facility (ATF)

Select this main menu option to access the Application Trace Facility (ATF) to trace the execution of a DB2 application.

The information gathered in these traces helps in the analysis of application flow and resource consumption. The Application Trace Facility provides the following types of performance information:
  • SQL trace information including static host variables and dynamic parameter markers
  • Sort activity information
  • Pageset access and scan information
  • Locking information
  • Application In-DB2 time and In-DB2 CPU time

The data that is collected by the Application Trace Facility is stored in a VSAM file or resident in memory. If the data is not stored in a VSAM file, it is only available for the current OMEGAMON® for Db2 PE session.

All Application Trace Facility (ATF) panels show the current state of an application trace, including a possible trace data set full condition, as ABENDED, ACTIVE, INACTIVE, or DSN FULL. A state of INIT-XXX might be shown briefly during early stages of initialization. For more information, see the description of panel View the Active In-Memory Non-Dataset Trace.