Candle-lite DB2 - Manual (Page 72)

System Status Components and Related Exceptions
72 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
Inactive thread exceptions
The following exceptions apply to inactive threads. An inactive thread does not hold any
cursors or database resources, but remains connected to DB2.
Buffer pool exceptions
The following exceptions apply to buffer pool resources.
Thread elapsed time ETIM The elapsed time for a DB2 thread (from sign-on or create
thread) exceeds the specified threshold.
Thread terminated
indoubt INDB The thread has terminated and is indoubt.
Update commit COMT The ratio of updates to commits for the thread exceeds the
specified threshold.
Wait for archive log
mode WLGQ The amount of time that a thread has been suspended due
to ARCHIVE LOG MODE (QUIESCE) exceeds the specified
threshold value.
Wait for DB2 service WSRV The amount of time a thread has been waiting for a DB2
service to complete exceeds the specified threshold value.
Wait for
thread-create CTHD An application is waiting for DB2 to create a thread.
Stored procedure
wait WSPS The amount of time a thread has been waiting for an
available TCB to schedule a stored procedure exceeds the
specified threshold.
Description Code Explanation
DBAT over maximum
wait MDBW The number of distributed data access threads (DBAT)
waiting because the preset maximum has been reached
exceeds the specified threshold.
Queuing of conversations when the MAXDBAT limit is
reached can greatly impact response time.
Description Code Explanation
Buffer pool utilization BMTH Buffer pool nn has exceeded the specified threshold.
Description Code Explanation