IBM Support

PK97593: CICS DB2 CONNECTION HANGS IN DISCONNECTING STATUS IF A CONNECT ATTEMPT IS MADE WITH A DB2GROUPID AND IT FAILS WITH A DFHDB2047I

A fix is available

Subscribe

You can track all active APARs for this component.

 

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
    

Publications Referenced
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