Candle-lite DB2 manual EDM pool exceptions, Lock statistics exceptions, Log manager exceptions

Models: DB2

1 132
Download 132 pages 16.76 Kb
Page 73
Image 73

System Status Components and Related Exceptions

EDM pool exceptions

The following exceptions apply to EDM pool 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.

 

 

 

Lock statistics exceptions

The following exception applies to lock statistics resources.

Description

Code

Explanation

 

 

 

Lock conflict

SUSL

The number of threads that are unable to continue

suspensions

 

execution because of lock waits exceeds the specified

 

 

threshold.

 

 

 

Log manager exceptions

The following exceptions apply to log manager resources.

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.

 

 

 

DDF statistics exceptions

The following exceptions apply to DDF resources.

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.

 

 

 

Using OMEGAMON II

73

Page 73
Image 73
Candle-lite DB2 manual EDM pool exceptions, Lock statistics exceptions, Log manager exceptions, DDF statistics exceptions