Data classes


Related topic

Output-group-considerations121_BASE

You can choose from the following data classes to specify the BMC IFCIDs or Db2 IFCIDs that are captured and stored by each output group:

Important

For further information regarding Db2 IFCIDS, see the section of the BMC AMI Ops Monitor for Db2 documentationthat refers to DB* data classes.

Data Class

IFCIDs

APSTACC

Apptune/SQL Performance BMC IFCIDs:

  • 006—Interval Statistics
  • 307—SQL Statement Summary
  • 318—Filter data
  • 507—SQL Statement Summary (Standard)

APSTACCS

Apptune/SQL Performance BMC IFCIDs:

  • 305—MainView Application Summary
  • 306—High Use Statement Summary (unless ALERTS class is active)
  • 308–311—Statement Summary
  • 506—High Use Statement Summary (Standard) (unless ALERTS class is active)
  • 508-511—Statement Summary (Standard)

APSTMT

Apptune/SQL Performance BMC IFCIDs:

  • 004—SQL Exceptions
  • 005—SQL Statement Text
  • 010—Host Variables
  • 011—Object statistics per SQL Exception
  • 012—Call stack info per exception

APERROR

Apptune/SQL Performance BMC IFCIDs:

  • 007—SQL Errors
  • 013—Apptune- Incompatible SQL Statement

APOBJECT

Apptune/SQL Performance Object Statistics. BMC IFCIDs:

  • 008—SQL Statement/Object Cross-Reference
  • 009—Access Object Statistics

(BMC.DB2.SPE2310)

  • 020—Table space real-time statistics
  • 021—Index real-time statistics

HOSTVAR

Specify Y to send Db2 and Apptunehost variable data to this output group. If no output group specifies Y for this class, then the host variable data will go to the DB2PERF output group for Db2 or APSTMT output group for Apptune. If you specify Y for this class, all others must be N.

Apptuneand BMC AMI Ops Monitor for Db2

BMC IFCID:

  • 10—Host variable

DB2 IFCIDs

  • 247-248—Host variable

ALERTS

Specify Y to send Apptunedata that can be the basis of alerts to this output group. If no output group specifies Y for this class, then the alerts data will go to the APPSTACC output group. If you specify Y for this class, all others must be N.

Apptune/ SQL Performance BMC IFCID:

  • 306—High Use Statement Summary (Advanced)
  • 506—High Use Statement Summary (Standard)

Some types of data (interval data) are summarized in an internal reduction table in a common data space. At the end of an interval, the product writes the contents of the reduction table (the summarized data) to logfiles. This can be a large amount of data, depending on the size of the reduction table and the number of Db2 objects.

The following types of data are categorized as interval data:

  • Interval data (BMC IFCID 006)
  • Filter data (BMC IFCID 318)
  • Statement object data (BMC IFCID 008)
  • Accessed objects data (BMC IFCID 009)
  • Statement summaries (BMC IFCIDs 307–310)
  • (BMC.DB2.SPE2310) Table space real-time statistics (BMC IFCID 020)
  • (BMC.DB2.SPE2310) Index real-time statistics (BMC IFCID 021)

Other data (event data) is written immediately to the logfiles. The following types of data are categorized as event data:

  • Statement text data (BMC IFCID 005)
  • SQL error data (BMC IFCID 007)
  • Exception data (BMC IFCID 004)
  • Host variable data (BMC IFCID 010)
  • Exception object data (BMC IFCID 011)

Data classes are used to logically group data for storage in log data sets. A logset can be defined to contain one or more data classes.

 

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