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