
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 |
| 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 |
|
| functions. It can be an integer from 0 to 99. |
|
| functions can be executed only from |
|
| procedure address spaces. UFAC is a member of the DB2 |
|
| system (SY) group. The default threshold is 3 and the default |
|
| state is On. |
|
|
|