Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

IFCID table (ATRAC data collection)

The data collection category used with the TYPE parameter of the ATRAC trace data collection service specifies the type of data to be collected.

Each type specifies a set of IFCIDs as shown in the table that follows. The BBI-SS PAS issues an internal -STA TRACE command to collect these IFCIDs.

  • D (DETAIL) collects the majority of the IFCIDs required by the DTRAC service.
  • SQL includes all detail events plus SQL statements.
  • SCAN includes all detail events plus scan and SQL events.
  • IO includes all detail events plus I/O events.
  • LOCK includes all detail events plus lock requests.
  • DDF includes all detail events plus all DDF events except VTAM-related DDF events.
  • DDFVTAM includes all detail events plus VTAM-related DDF events.

Note

Each additional category incurs more overhead and requires larger internal trace buffers.

IFI data collection in the BBI-SS PAS pairs start and end IFCID records for an event where they exist so that the elapsed time can be calculated, and the DTRAC service shows a single event line for start/end. Some events do not have an end event; therefore, the elapsed time cannot be calculated.

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*