beautypg.com

Active trace exceptions, Volume activity exceptions, Stored procedures exceptions – Candle-lite DB2 User Manual

Page 75

background image

Using OMEGAMON II

75

System Status Components and Related Exceptions

Active trace exceptions

The following exceptions apply to active trace alerts.

Volume activity exceptions

The following exceptions apply to volume activity alerts.

Stored procedures exceptions

The following exceptions apply to stored procedures alerts.

Description

Code

Explanation

DB2 global trace
active

GTRC

The DB2 global trace is active. It should not be active unless
there is a specific purpose, such as diagnostic testing. The
DB2 global trace can increase performance overhead.

Description

Code

Explanation

Volume DB2 I/O rate

VDIO

A DB2 I/O rate per second for the volume exceeded the
specified threshold.

Volume extents per
DSN

VEDR

The dataset-to-dataset extent ratio of a volume exceeded
the specified threshold.

Volume service time

VSRV

The service time for the volume exceeded the specified
threshold. The threshold is expressed in milliseconds and
must be an integer between 0–9999.

Volume TL I/O rate

VTIO

The total I/O rate per second for the volume exceeded the
specified threshold. The threshold is the total number of
I/Os per second and must be an integer between 0–9999.

Volume utilization

VUTL

The utilization percentage for the volume exceeded the
specified threshold. The threshold is a percentage and must
be an integer between 0–100.

Description

Code

Explanation

ASIDs executing
stored procedures

SPAC

Indicates that the number of ASIDs executing stored
procedures exceeds the threshold. The threshold is
expressed as a count of address spaces capable of executing
stored procedures. It can be an integer from 0 to 99. Stored
procedures can be executed in a DB2 stored procedure
address space and in any WLM-managed stored procedure
address space. SPAC is a member of the DB2 system (SY)
group. The default threshold is 3 and the default state is On.