Dependent regions monitors


The dependent region monitors provide performance data about Db2 access by programs executing in the dependent regions.

Resource monitors for dependent regions

Monitor name

Description

View name

CHKPT

Number of checkpoints by BMP

This monitor reports the total number of checkpoint calls performed since the BMP region started.

ICHKPT

DBGU

DL/I database calls

This service monitors the total number of DL/I database calls by region and issues a warning if the threshold is exceeded.

The number of calls is calculated as the number of DL/I database calls performed in the specified region since the last scheduling divided by the number of MESSAGE GET UNIQUEs performed. Fast Path calls are not included.

None

DBTOT

DB CALLS/SCHED BY RGN

This service monitors the number of database DL/I calls performed since the last scheduling by region and issues a warning if the threshold is exceeded.

The number of calls is calculated as the number of DL/I database calls performed in the specified region since the last scheduling (measured at the time of the sample) compared to the warning threshold. Fast Path calls are not included.

None

D2CON

Region connection to Db2 subsystem

This monitor reports the number of dependent regions connected to Db2 during the sampling period. Depending on the parameters specified with the monitor, the reported value is the total number of regions connected to Db2 subsystems or the number of regions connected to a specific Db2 subsystem.

ID2CON

D2SON

Db2 sign-on by subsystem

This monitor reports the number of dependent regions that issued at least one SQL call and are signed on to Db2 during the sampling period. Depending on the parameters specified with the monitor, the reported value is the total number of regions signed on to Db2 or the regions signed on to a specific Db2 subsystem.

ID2SON

D2THD

Region threads to Db2 subsystem

This monitor reports the number of dependent regions with active threads to Db2 during the sampling period. Depending on the parameters specified with the monitor, the reported value is the total number of active regions with Db2 threads or the regions with active threads to a specific Db2 subsystem.

ID2THD

DLIDB

DL/I DB call time

This monitor reports the number of seconds that the database DL/I call has lasted. Depending on the parameters specified with the monitor, the reported value is for all regions, for all regions except BMPs and JBPs, or for a specified region only.

IDLIDB

DLIDC

DL/I DC call time

This monitor reports the number of seconds that the transaction DL/I call has lasted. Depending on the parameters specified with the monitor, the reported value is for all regions, for only GU calls to the I/O PCB, for only GU calls to the I/O PCB for non-WFI and non-PWFI transactions, for all regions except WFI regions, or for a specified region only.

IDLIDC

MSGGU

Message CALLS/MGU by region

This service monitors DL/I message queue calls by region and issues a warning if the threshold is exceeded.

The number of calls is calculated by the number of DL/I message queue calls performed in the specified region since the last scheduling divided by the number of MESSAGE GET UNIQUEs performed (both as measured and at the time of the sample). Fast Path calls are not included.

None

MSGT

Message CALLS/SCHED by region

This service monitors DL/I message queue calls by region and issues a warning if the threshold is exceeded.

The number of calls is calculated by the number of DL/I message queue calls performed in the specified region since the last scheduling (as measured at the time of the sample). Fast Path calls are not included.

None

MXPST

Active regions

This service reports the number of active regions.

None

WAIT

Region in a long PI WAIT

This service monitors regions for excessive PI wait times.

A warning is written when any region is detected to be in a long PI wait (exceeding the threshold value, defined in seconds).

This service can show only one region exception at a time. When the warning condition in one region is cleared, the service continues to check other regions until another exception condition is found and displayed.

None

 

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

BMC AMI Ops Monitor for IMS Online 5.6