System Status Components and Related Exceptions

Description

Code

Explanation

 

 

 

Number of stored

STPE

Indicates that the number of stored procedures executing

procedures executing

 

exceeds the threshold. The threshold is expressed as a count

 

 

of stored procedures currently executing. It can be an

 

 

integer from 0 to 99. STPE is a member of the DB2 system

 

 

(SY) group. The default threshold is 10 and the default state

 

 

is On.

 

 

 

Triggers exceptions

The following exceptions apply to alerts relating to triggers.

Description

Code

Explanation

 

 

 

Depth of largest

TRGD

Indicates that the depth of the largest trigger stack exceeds

trigger stack

 

the threshold. The threshold is expressed as the number of

 

 

triggers in the largest trigger stack. The threshold can be an

 

 

integer from 0 to 99.TRGD is a member of the DB2 system

 

 

(SY) group. The default is 1 and the default state is On.

 

 

 

Number of triggers

TRGE

Indicates that the number of triggers executing exceeds the

executing

 

threshold. The threshold is expressed as a count of triggers

 

 

currently executing. The threshold can be an integer from 0

 

 

to 99. TRGE is a member of the DB2 system (SY) group.

 

 

The default threshold is 10 and the default state is On.

 

 

 

User-defined functions exceptions

The following exceptions apply to user-defined functions.

Description

Code

Explanation

 

 

 

Number of

UDFE

Indicates that the number of user-defined functions

user-defined

 

executing exceeds the threshold. The threshold is expressed

functions executing

 

as a count of user functions currently executing. The

 

 

threshold can be an integer from 0 to 99. UDFE is a member

 

 

of the DB2 system (SY) group. The default threshold is 10

 

 

and the default state is On.

 

 

 

Number of ASIDS

UFAC

Indicates that the number of ASIDs executing user functions

executing user

 

exceeds the threshold. The threshold is expressed as a count

functions

 

of address spaces capable of executing user-defined

 

 

functions. It can be an integer from 0 to 99. User-defined

 

 

functions can be executed only from WLM-managed stored

 

 

procedure address spaces. UFAC is a member of the DB2

 

 

system (SY) group. The default threshold is 3 and the default

 

 

state is On.

 

 

 

76 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540

Page 76
Image 76
Candle-lite DB2 manual Triggers exceptions, User-defined functions exceptions