Candle-lite DB2 - Manual (Page 76)

System Status Components and Related Exceptions
76 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Triggers exceptions
The following exceptions apply to alerts relating to triggers.
User-defined functions exceptions
The following exceptions apply to user-defined functions.
Number of stored
procedures executing STPE Indicates that the number of stored 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.
Description Code Explanation
Depth of largest
trigger stack TRGD Indicates that the depth of the largest trigger stack exceeds
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
executing TRGE Indicates that the number of triggers executing exceeds the
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.
Description Code Explanation
Number of
user-defined
functions executing UDFE Indicates that the number of user-defined functions
executing exceeds the threshold. The threshold is expressed
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
executing user
functions UFAC Indicates that the number of ASIDs executing user functions
exceeds the threshold. The threshold is expressed as a count
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.
Description Code Explanation