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

DFHD2EX1

XMEOUT parameters/Message inserts

  1. date
  2. time
  3. applid
  4. tranid
  5. resname

Destination

CDB2



DFHDB2011.html | Timestamp icon Last updated: Sunday, 4 June 2017