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