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, see BMC AMI Ops Infrastructure 7.1.

Db2 metrics provided by monitors


The metrics in the following table are available from the 

MainView for DB2

 background monitors.

You can specify monitor options, such as WIF, to ensure that a condition persists for a certain number of intervals before issuing a warning. For more information about monitor options, see MainView for DB2.


Metric

Indicates

Monitor

Monitor message

Recommended monitor values

Class B - Performance metrics

Archive impacts

Potential service disruption because the job that archives the active log is waiting to execute

Various monitors

DZ0030I

None

DDF threads and connections

various monitors show queuing or low allocations

This metric is also available in a view. See Db2-metrics-provided-by-views.

CNVLM

DS1160W

WVAL>0

DBTQD

DS0650W

WVAL>0

DBTUT

DS1680W

WVAL>80%

RMTUT

DS1210W

WVAL>80%

Locking

Deadlocks, timeouts, escalations, and suspensions

LTIME

DS0280W

WVAL=3

GSUSP

DS1430W

WVAL=3

LDEAD

DS0260W

WVAL=3

LESCL

DS0290W

WVAL=3

Response - thread average elapsed time in Db2

Response or elapsed time issues

This metric is also available in a view. See Db2-metrics-provided-by-views.

@ELPD

DW0150W

WVAL=5

Runaway threads

A thread with an attach type of xxx for user xxxxxxxx is using resources that exceed the defined thresholds

Runaway threads can be monitored for a number of conditions including CPU usage, Elapsed time and number of Get pages.

DMRBEX

DZ06nnW

MSG=DZ06nnW, ACTIVE=YES, CYC LES=4, ELAPSED=7200, CPU=0

Threshold=120 seconds of elapsed time

Related topic

 

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