DFHDB2011 date time applid tranid Transaction abended because threads are unavailable for resource resname
Explanation
The transaction was abnormally terminated because a thread connection to DB2 was not available for the transaction. Resname identifies the name of the DB2ENTRY or the POOL from which the thread was to be allocated. This error can occur when:
-
The DB2ENTRY specifies Threadwait(no) and all threads are currently being used.
-
The DB2ENTRY specified Threadwait(pool), but the pool definition within the DB2CONN specifies Threadwait(no), and all threads are currently being used both in the DB2ENTRY and the Pool.
-
The transaction was using the pool directly, the pool specifies Threadwait(no) and all pool threads are currently in use.
System action
The transaction is abnormally terminated.
User response
Determine if more threads can be made available to the DB2ENTRY or the POOL by increasing the THREADLIMIT value on the DB2ENTRY or the DB2CONN respectively. The THREADLIMIT value can be increased using SET DB2ENTRY and SET DB2CONN commands.
Module
XMEOUT parameters/Message inserts
- date
- time
- applid
- tranid
- resname
Destination
CDB2