![](/images/new-backgrounds/1263700/263700143x1.webp)
System Status Components and Related Exceptions
Description | Code | Explanation |
|
|
|
Thread elapsed time | ETIM | The elapsed time for a DB2 thread (from |
|
| thread) exceeds the specified threshold. |
|
|
|
Thread terminated | INDB | The thread has terminated and is indoubt. |
indoubt |
|
|
|
|
|
Update commit | COMT | The ratio of updates to commits for the thread exceeds the |
|
| specified threshold. |
|
|
|
Wait for archive log | WLGQ | The amount of time that a thread has been suspended due |
mode |
| 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 | CTHD | An application is waiting for DB2 to create a thread. |
|
| |
|
|
|
Stored procedure | WSPS | The amount of time a thread has been waiting for an |
wait |
| available TCB to schedule a stored procedure exceeds the |
|
| specified threshold. |
|
|
|
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.
Description | Code | Explanation |
|
|
|
DBAT over maximum | MDBW | The number of distributed data access threads (DBAT) |
wait |
| 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. |
|
|
|
Buffer pool exceptions
The following exceptions apply to buffer pool resources.
Description | Code | Explanation |
|
|
|
Buffer pool utilization | BMTH | Buffer pool nn has exceeded the specified threshold. |
|
|
|