IBM Support

Resolving CDB2RDYQ *POOL waits in CICS by finding tasks that own DB2 pool threads

Question & Answer


Question

The Dispatacher domain in my CICS dump shows tasks waiting on resource CDB2RDYQ *POOL. This means tasks are waiting for DB2 pool threads. How can I tell which tasks in my CICS region own the DB2 pool threads?

Answer

Format the CICS-DB2 control blocks with VERBX DFHPDxxx 'DB2' (where xxx is your release level of CICS like 690 for CICS TS 5.2).

Page forward until you see the DB2 Transaction Summary.

Tasks that own the DB2 threads will have a non-zero address in the CsubAddr column and a non-blank Correlation ID.

For example, here is a DB2 Transaction Summary formatted by CICS:

alt text

From this example, it is task #'s 59852, 59884, 59001, 59882, and 59002 that own the DB2 pool threads.

You can then search on the task number in the Dispatcher domain (VERBX DFHPDxxx 'DS=1') to find out what the task holding the DB2 pool thread is waiting for.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"DB2","Version":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Product Synonym

CICS/TS CICSTS CICS TS CICS Transaction Server

Document Information

Modified date:
16 December 2014

UID

dwa1167405