Db2 metrics
Related topics
BMC AMI Ops Monitor for Db2 views and background monitors provide important metrics for Db2. These are described in the following topics:
Db2 metrics provided by views
The following metrics are available in the BMC AMI Ops Monitor for Db2 views. For information about using this table, see Using the metric tables.
Before you create alarms based on these metrics, review Planning.
Metric | Indicates | View name Field name Element name | Recommended view filter | Recommended field threshold (adjust for site-specific processing) |
|---|---|---|---|---|
Class A - Availability metrics | ||||
Region availability | Whether critical Db2 regions are available | PLEX Status STATUS | AREA == ‘Db2’ | STATUS 'ACTIVE' |
STWARN DB2 Connect Failure STFLAG19 | None | STFLAG19 'NO' | ||
Resource availability | The status of critical databases or objects | OBJLIST Access O100ACC | O100DBNM IN (dbn1, dbn2) OR O100PSNM IN (obj1, obj2) | O100ACC NOT RW OR STATUS NOT '' |
Class B - Performance metrics | ||||
Archive impacts | This metric is provided by a monitor. See Db2-metrics-provided-by-views. | |||
DBM1 storage utilization | Available storage is too low | DB2STOR Available < 2GBAVLSTORG | None | AVLSTORG< 200 (MB) |
DDF threads and connections | This metric is provided by a monitor. See Db2-metrics-provided-by-views. | |||
General performance status | Overview of Db2 activity | STDB2 Act Thrd STATOT | STDB2TARG IN (rgn1, rgn2) | STATOT > thresh OR STATOT < thresh) OR (SISCOMIT > thresh) OR (SISGET > thresh) OR (STEXTOT '') |
General performance status | Failure or degradation | STWARN(30 conditions are monitored on this view) Warning STWRNFLG | None | STWRNFLG '' |
Locking | This metric is provided by a monitor. See Db2-metrics-provided-by-monitors. | |||
Lockouts | Timeout or deadlock events | LKEVENT any field any element | None | any data in these views represents an event that might indicate a problem |
LKEVSSI any field any element | None |
| ||
Locks - user | Contention problems and work not completing due to deadlocks and timeouts | STLOCK provides 15 minute average of various deadlocks any field any element | MONPARM IN (wkld1, wkld2, wkld3) | any element > 0 |
Response - thread average elapsed time in Db2 | Response or elapsed time issues This metric is also available from a monitor. See Db2-metrics-provided-by-monitors. | THDACTV Elapsed TimeUTRNELAP CPU TimeUTCBTIME | Filter out long running threads | UTRNELAP > site-specific threshold |
UTCBTIME > site-specific threshold | ||||
Users suspended for lock | Current thread lock wait times | LSTSUSPZ Lock Wait Time L100LELP | None | L100LELP > 2 |
Workload objectives | How well workloads are meeting response objectives | DOBJ % <= Resp Goal MONIPOBJ | MONPARM IN (wkld1, wkld2, wkld3) | MONIPOBJ < 100 |
Db2 metrics provided by monitors
The metrics in the following table are available from the BMC AMI Ops Monitor 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 BMC AMI Ops Monitor 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 |