Categories and KPI Groups


BMC AMI Ops Insight monitors the following Categories and KPI groups:

Category

KPI Group

Resource type

Description

Contention

Delay caused by competition for system resources; for example suspends due to waits for locks or latches

Global Contention

Db2

Activities related to the suspension due to global resource contention

Local Contention

Db2

Activities related to the local contention, such as suspension due to lock, latch contention

Page Plock Activity

Db2

Activities related to the page p-lock request and contention

ENQUEUES

LPAR

Activities related to the total number of contention events that occurred during the measurement interval

IMS Latch ContentionIMSActivities related to IMS Latch Contention
IMS TRXN Latch Wait TimeIMSActivities related to IMS Transaction Time waiting for latch
IMS TRXN Lock Wait TimeIMSActivities related to IMS Transaction Time waiting for lock

CPU 

Amount of time spent on general processors and zIIP engines

Db2 CPU Times for zIIP

Db2

Activities related to the CPU usage on a zIIP CP for Db2 address spaces

Db2 CPU Times for GP

Db2

Activities related to CPU usage on a general CP for Db2 address spaces

IRLM CPU Times

Db2

Activities related to CPU usage on a general CP for IRLM address spaces

CPU Busy CP

LPAR

Activities related to the average percentage of the online time that the general purpose logical processors were busy. 

CPU Busy zIIP LPARActivities related to the average percentage of the online time that the zIIP processors were busy.

WLM CPU Capping Delay

LPAR

Activities related to the CPU Capping delay

WLM CPU Consumption SRB

LPAR

Activities related to the WLM SRB service units

WLM CPU Consumption TCB

LPAR

Activities related to the WLM CPU service units

WLM CPU Consumption zIIP

LPAR

Total service units on zIIPs by WLM importance

WLM CPU Consumption zIIP Redirect

LPAR

Total service units on CPs spent by zIIP eligible work by WLM importance

WLM CPU Delay

LPAR

Activities related to the CPU delay

IMS CPU Usage

IMSActivities related to the CPU usage by IMS processing
IMS TRXN CPU UsageIMSActivities related to the CPU usage by IMS regions type
MVS CPU UsageIMSActivities related to the CPU usage by MVS

I/O

Local Buffer Pool and Group Buffer Pool related read/write activities, and data set open/close activities

Related Resources

Bufferpool Read

Db2

Buffer pool read activities, such as synchronous read, asynchronous read, etc.

Bufferpool Write

Db2

Buffer pool write activities, such as pages written, synchronous writes, etc.

Dataset Activities

Db2

Activities related to the data sets open/close

Dataset Usage

Db2

Page sets in use and allocated

Group Bufferpool Castout

Db2 Data Sharing Group

Activities related to the process of writing pages from Group Buffer Pool to DASD

Group Bufferpool Read/Write

Db2

Group Buffer Pool read and write activities, such as getpage requests, changed page written synchronously or asynchronously

IO Request

LPAR

Activities related to the number of I/O requests

WLM DASD I/O Request

LPAR

Activities related to the DASD I/O count

WLM DASD I/O Time

LPAR

Activities related to the DASD I/O connect time, wait time and disconnect time

WLM I/O Time

LPAR

Activities related to the I/O interrupt time

IMS DEDB I/O

IMSActivities related to IMS DEDB I/O
IMS DEDB I/O RespIMSActivities related to IMS DEDB I/O Response Time
IMS Fullfunction DB I/OIMSActivities related to IMS DB Fullfunction I/O
IMS Fullfunction DB I/O RespIMSActivities related to IMS DB Fullfunction I/O Response Time
IMS OSAM POOL HIT RATIOIMSActivities related to IMS OSAM Pool
IMS VSAM POOL HIT RATIOIMSActivities related to IMS VSAM Pool
IMS TRXN DB I/O TimeIMSActivities related to IMS Transaction Time waiting for I/O to IMS Database

Real Storage

The physical storage availability and usage on the mainframe processor

Auxiliary Usage Rate

Db2

Activities related to the auxiliary storage usage by Db2 address space

LPAR Paging Activity

LPAR

Paging activities on the LPAR

LPAR Real Storage Available

Db2

The availability of the real storage

Real/Auxiliary Storage Usage

Db2

Activities related to real and auxiliary storage usage by Db2 address spaces

IMS Paging Activity

IMSActivities related to IMS Paging
IMS Real Storage UsageIMSActivities related to IMS real storage usage

Virtual Storage

Virtual storage usage for DBM1, DIST, and IRLM address spaces, and shared storage usage, including working storage for user and system tasks

Common Storage 64bit

Db2

Activities related to the 64-bit Common Storage usage

LPAR Common Storage 31bit

Db2

Activities related to the 31-bit Common Storage usage

Shared Agent Storage

Db2

Activities related to the working storage for user and system tasks

Shared Virtual Storage 64bit

Db2

Activities related to the 64-bit shared storage in use

Virtual Storage DBM1 31bit

Db2

Activities related to the 31-bit virtual storage usage for the DBM1 address space

Virtual Storage DBM1 64bit

Db2

Activities related to the 64-bit virtual storage usage for the DBM1 address space

Virtual Storage DIST 31bit

Db2

Activities related to the 31-bit virtual storage usage for the DIST address space

Virtual Storage DIST 64bit

Db2

Activities related to the 64-bit virtual storage usage for the DIST address space

Virtual Storage IRLM

Db2

Activities related to virtual storage usage for the IRLM address space

DLISAS Virtual Storage Usage

IMSActivities related to DLISAS virtual storage usage
IMS Pool Storage UsageIMSActivities related to IMS Pool Current Allocation
IMSCTL Virtual Storage UsageIMSActivities related to IMS Control Region virtual storage usage

Workload

Amount of work that the system processes during a given interval, also includes thread management

DDF activities AR

Db2

DDF activities initiated from this site to a remote site

DDF activities AS

Db2

DDF activities initiated from a remote site to this site

DML

Db2

Activities related to the Data Manipulation Language requests to a Db2 subsystem

Global DDF Activity

Db2

The general DDF activities, such as connections, database access threads (DBATs), etc.

IRLM Requests

Db2

Activities related to the IRLM requests, such as locks, unlocks, query requests, also include claims and drains requests.

Log Read Activity

Db2

Log manager log read activities, such as reading log records from the log output buffer

Log Write Activity

Db2

Log manager log write activities, such as the log write requests, the log CI written

System Engine Counts

Db2

Activities related to the number of system engines in the system

Thread Counts

Db2

Activities related to the number of active allied threads, active and disconnected database access threads (DBATs)

Thread Management

Db2

Activities related to Thread management, such as thread creation and thread termination

Throughput

Db2

Activities related to the transactions that were completed in the given interval

XES Requests

Db2

Activities related to the Coupling Facility requests

CF Activity

LPAR

Coupling facility activity based on synchronous and asynchronous requests, including locking requests and requests changed from asynchronous to synchronous

WLM Transaction Rate

LPAR

Activities related to the transaction completion and phase completion counts

WLM Transaction TimeLPARActivities related to the transaction active, elapsed, and execution times

XCF Activity

LPAR

XCF activity based on numbers of signals sent and received, message too small conditions, and path not busy counts

XCF Time

LPAR

Activities related to the average I/O transfer time for inbound paths in the last minute of the reporting interval

BMP/JBP TRXN DLI Time

IMSActivities related to the BMP Transaction DLI Time distribution Percentage
BMP/JBP TRXN TimeIMSActivities related to the BMP Transaction Time distribution Percentage
IFP TRXN DLI TimeIMSActivities related to the IFP Transaction DLI Time distribution Percentage
IFP TRXN TimeIMSActivities related to the IFP Transaction Time distribution Percentage
IMS DLI CALL RespIMSActivities related to IMS DLI Call Response
IMS DLI TOTCALLIMSActivities related to IMS DLI Calls
IMS Log Read/Write ActivitiesIMSActivities related to IMS Logger Read/Write Activity
IMS Message QueueIMSActivities related to the IMS Message count
IMS Region OccupancyIMSActivities related to the IMS Region occupancy
IMS ThroughputIMSActivities related to IMS Throughput
IMS TRXN Elapsed TimeIMSActivities related to IMS Transaction Elapsed Time
IMS TRXN Response TimeIMSActivities related to MPR region Transaction Response Time
IMS WADS Write ActivitiesIMSActivities related to IMS WADS Write Activity
MPR/JMP TRXN DLI TimeIMSActivities related to the MPR/JMP Transaction DLI Time distribution Percentage
MPR/JMP TRXN TimeIMSActivities related to the MPR/JMP Transaction Time distribution Percentage

Exception KPIs for Db2, z/OS, and IMS

Db2 exceptionsDescription
Q3STCTHWThe number of queued create thread requests
QBGL2FThe number of sec-GBP write failures due to a lack of coupling facility storage
QBGLWFThe number of GBP write failures due to a lack of coupling facility storage
QBSTDMCThe number of times the data manager critical threshold DMTH was reached
QBSTLPLThe number of times that one or more pages were added to the LPL
QBSTREEThe total number of times a prefetch was disabled because of an unavailable read engine
QBSTSPDThe number of times sequential prefetch was disabled because buffers were not available
QBSTXFLThe number of times a buffer could not be allocated because the virtual buffer pool is full
QDSTNCCWThe number of queued client connections whose TCP/IP socket were closed due to MAXCONQW being exceeded
QDSTNCQCThe number of queued client connections whose TCP/IP socket were closed due to MAXCONQN being exceeded
QDSTNQR2The current number of type 2 inactive or new connections that are queued waiting for a DBAT
QDSTQCRTThe number of connections that were rejected because the ZPARM limitation CONDBAT was reached
QDSTQDBTThe number of times a DBAT/connection was queued because the ZPARM limitation MAXDBAT was reached
QISECFALThe number of failures because the Global Dynamic Statement Cache was full
QISEDFALTotal number of failures because the DBD Pool above the 2GB bar was full
QJSTWTBThe number of waits caused by an unavailable output log buffer
QLSTFSECThe number of failed security authentications
QLSTHCRSRThe number of with hold cursor is not close
 
z/OS exceptionsDescription
R742PIBRNormalized number of inbound signals refused due to the maximum message limit
R742PQLNNormalized number of outbound signals pending transfer on the path
R742SNOPNormalized number of no path conditions
R744FPBCNormalized number of times the CF request failed due to the path being busy
 
IMS exceptionsDescription
GIMSOIEXCNumber of regions with excess CPU usage
GIMSOIEXDNumber of regions with excess DLI calls
GIMSOIEXENumber of classes with excess elapsed time
GIMSOIEXINumber of classes with excess input queue time
GIMSOIEXONumber of regions with excess occupancy time
GIMSOIEXSNumber of regions with excess SQL calls
GIMSOINSMThe average non-schedulable message count for this IMS
LSBUFRLogger buffer wait rate
LTWTCTCTotal latch wait count since last checkpoint
LTWTTLCTotal latch wait time since last checkpoint

 

 

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

BMC AMI Ops Insight 3.0