Candle-lite DB2 - Manual (Page 74)

System Status Components and Related Exceptions
74 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
DB2 activity exceptions
The following exceptions apply to DB2 activity alerts.
Lock exceptions
The following exceptions apply to lock alerts.
DDF send rate DSND The amount of data sent to a requestor (local) or server
(remote) DB2 subsystem exceeds the specified threshold.
Max logmode
conversations MCNV The number of conversations in use exceeds the specified
threshold. When the percentage reaches 100%, the
exception message displays the number of threads waiting
because the preset maximum is exceeded.
Queuing conversations can greatly increase response time.
Description Code Explanation
Create-thread waits THDQ The number of users waiting for create thread processing
exceeds the specified threshold.
Indoubt threads INDT The number of terminated threads that are indoubt exceeds
the specified threshold.
Thread use % TMAX The percentage of active threads to the specified maximum
exceeds the specified threshold.
Description Code Explanation
Resource wait time WTRE The amount of time a thread is waiting for a resource
exceeds the specified threshold.
Wait for drain lock WDLK The amount of time a thread has been waiting for a drain
lock exceeds the specified threshold.
Wait for drain of
claims WCLM The amount of time a utility has been waiting for claims to
be released after acquiring drain lock exceeds the specified
threshold.
Global lock wait WGLK The amount of time a thread has been waiting for a global
lock exceeds the specified threshold.
Description Code Explanation