Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, seeBMC AMI Ops Monitor for IMS Online 5.5.

DB2 activity monitors

The DB2 activity monitors provide performance data about DB2 calls made through the IMS Attach facility and usage of dependent region CPU time for DB2 requests made by a transaction.

Workload monitors for DB2 activity

Monitor name

Description

View name

#CDB2

DB2 data access calls

This monitor reports the number of SQL calls to DB2 to access data tables for selected workloads during the sampling period. Depending on the parameters specified with the monitor, the reported value is the number of SQL calls to DB2 for the total workload or for a single workload type.

I#CDB2

#SDB2

DB2 non-data access calls

This monitor reports the number of non-data-access SQL calls (DDL, dynamic, and control-type calls) to DB2 for selected workloads during the sampling period. Depending on the parameters specified with the monitor, the reported value is the number of non-data-access SQL calls to DB2 for the total workload or for a single workload type.

I#SDB2

@PDB2

DB2 CPU time

This monitor reports the average CPU time used per transaction to process DB2 requests for selected workloads during the sampling period. Depending on the parameters specified with the monitor, the reported value is the average CPU time used by the total workload or by a single workload type.

I@PDB2


Related topic

IMS-workload-monitors



 

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