Db2 metrics provided by monitors
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 |