beautypg.com

Edm pool exceptions, Lock statistics exceptions, Log manager exceptions – Candle-lite DB2 User Manual

Page 73: Ddf statistics exceptions

background image

Using OMEGAMON II

73

System Status Components and Related Exceptions

EDM pool exceptions

The following exceptions apply to EDM pool resources.

Lock statistics exceptions

The following exception applies to lock statistics resources.

Log manager exceptions

The following exceptions apply to log manager resources.

DDF statistics exceptions

The following exceptions apply to DDF resources.

Description

Code

Explanation

EDM pool utilization

EDMU

The percentage of environmental descriptor manager
(EDM) pool pages in use to total pool size exceeds the
specified threshold.

Description

Code

Explanation

Lock conflict
suspensions

SUSL

The number of threads that are unable to continue
execution because of lock waits exceeds the specified
threshold.

Description

Code

Explanation

Primary logs available LOGN

The number of available primary active logs is less than or
equal to the specified threshold.

Recovery log archive

ARCV

An active DB2 log is full and must be archived, and a tape
mount is outstanding for the archive log.

Description

Code

Explanation

DBAT thread %

MDBT

The number of database access threads (DBAT) in use
exceeds the specified threshold.

When the MAXDBAT limit is reached, conversations are
queued (waiting on DBAT allocation), which can greatly
increase response time.

DDF not active

DDFS

The distributed data facility was requested for this DB2
subsystem but it is not active. This could indicate that the
DDF terminated abnormally or that it was not started.

DDF receive rate

DRCV

The amount of data received by a requestor (local) or server
(remote) DB2 subsystem in response to SQL requests
exceeds the specified threshold.