A fix is available
APAR status
Closed as program error.
Error description
CICS is started with the DB2 subsystem down. CICS then tries to connect to a DB2 subsystem using the DB2GROUPID attribute for the group attach facility, but the DB2 subsystem is not a data sharing group. Since DB2 is still not active, the DFHDB2037 message is produced. The DB2 subsystem starts up, and the DFHDB2047I message is produced stating that the CICS-DB2 Attachment cannot find DB2 group id. The connection hangs in disconnecting status, and CICS must be recycled to clear the hang. The CEX2 transaction is in an EKCWAIT CEX2TERM wait while holding the DFHD2GLB lock. Any CEMT queries against the connection will wait on the LMQUEUE lock for the D2GLB. CEX2 is never posted.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All. * **************************************************************** * PROBLEM DESCRIPTION: CICS DB2 connection hangs in * * disconnecting status. * **************************************************************** * RECOMMENDATION: * **************************************************************** A CICS DB2 connection may hang in a disconnecting status if a connection attempt is made with DB2GROUPID specified, but the name specified is a DB2 subsystem name. When CICS is started the DB2 subsystem is not active, and message DFHDB2037 is issued. DFHD2EX2 goes into a wait for DB2. The DB2 subsystem is then started, the wait in DFHD2EX2 is posted and DFHD2EX2 then issues another attempt to connect to DB2. However because the DB2GROUPID cannot be found message DFHDB2047I is issued and then a disconnect is started. Part of the disconnect logic is to terminate all thread subtasks, and DFHD2EX2 has to wait for the thread subtasks to be terminated. It does this by waiting on glb_service_task_stop_ecb, but it is only DFHD2EX2 which will post this ECB and so it waits forever. Keywords: MSGDFHDB2037 MSGDFHDB2047I DFHDB2047 MSGDFHDB2047 D2CO_DB2_GROUP_ID_INVALID D2CC_DB2_GROUP_ID_INVALID
Problem conclusion
The CICS DB2 attach modules have been altered to ensure the attachment is shutdown using the CDBF transaction. The CICS Transaction Server for z/OS V3.2 System Programming Reference Manual (SC34-6820-02) will have a new resp2 of 56, DB2GROUPID invalid, added to the INVREQ response for the SET DB2CONN command.
Temporary fix
FIX AVAILABLE BY PTF ONLY
Comments
APAR Information
APAR number
PK97593
Reported component name
CICSTS V3 Z/OS
Reported component ID
5655M1500
Reported release
500
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-30
Closed date
2009-12-18
Last modified date
2010-01-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PM02167 UK53101
Modules/Macros
DESD2CC DESD2CO DESD2STP DESD2STR DESD2TM DESEIQD2 DFHD2CC DFHD2CCA DFHD2CCM DFHD2CCR DFHD2CCT DFHD2CO DFHD2COA DFHD2COM DFHD2COR DFHD2COT DFHD2EX2 DFHD2STP DFHD2STR DFHD2TM DFHEIQD2
SC34682002 |
Fix information
Fixed component name
CICSTS V3 Z/OS
Fixed component ID
5655M1500
Applicable component levels
R500 PSY UK53101
UP09/12/25 P F912
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 January 2010