IBM Support

PM77724: PEER RECOVERY PH2 WAS NOT COMPLETED (CSQE014I IS NOT ISSUED) WHEN DB2 IS NOT AVAILABLE.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • PH2 PLR was started for application structure (CSQJ102I was
    issued), but not completed (CSQE014I was not issued) when DB2
    is not available.
    During PLR, CSQJ103E was issued from CSQJPB06, and Status code
    was 035C0002 which mean Invalid PARM specified in text unit,
    and also BSDS Dataset name field is blank in the message text
    of CSQJ103E.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of WebSphere MQ for z/OS Version 7 *
    *                 Release 0 Modification 1 and Release 1       *
    *                 Modification 0.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: On a queue manager that is attempting   *
    *                      peer level recovery that has no access  *
    *                      to DB2 a message CSQJ103E may be issued *
    *                      with an invalid dataset name. Also if   *
    *                      phase 2 peer level recovery is          *
    *                      attempting to recover binary large      *
    *                      objects (blobs) then CSQE159I is issued *
    *                      but is not followed by a CSQE014I       *
    *                      message to indicate that recovery has   *
    *                      completed.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A queue manager which is unable to access DB2 attempts to
    carry our peer level recovery, and in order to do this it
    calls CSQJDB21 (using CSQJ7LRE) to query DB2 for the dataset
    name of the failing queue managers BSDS. It receives a return
    code of CSQ5_DB2_UNAVAILABLE but doesn't handle it, and does not
    propagate the error back up the chain of callers. As a result
    the residual data which exists in the BMEM is used to try to
    open the BSDS which fails, causing CSQJ103E to be issued.
    In V701 only, if blobs are involved in phase 2 of the recovery
    CSQERWI2 attempts to clean them up. However because DB2 is
    unavailable this fails and CSQE159I is issued indicating
    orphaned blobs. However the local_return_code is set, and this
    causes early termination of peer level recovery so no
    CSQE014I message is issued.
    

Problem conclusion

  • CSQJDB21 now provides a RC=12 if its call to CSQ5READ or
    CSQ5UPDT returns CSQ5_DB2_UNAVAILABLE.
    CSQERWI2 no longer terminates phase 2 peer level recovery if
    orphaned blob deletion has failed.
    010Y
    100Y
    CSQERWI2
    CSQJDB21
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77724

  • Reported component name

    WMQ Z/OS V7

  • Reported component ID

    5655R3600

  • Reported release

    010

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-11-26

  • Closed date

    2013-03-22

  • Last modified date

    2013-06-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK92818 UK92819

Modules/Macros

  • CSQERWI2 CSQJDB21
    

Fix information

  • Fixed component name

    WMQ Z/OS V7

  • Fixed component ID

    5655R3600

Applicable component levels

  • R010 PSY UK92818

       UP13/05/08 P F305

  • R100 PSY UK92819

       UP13/05/08 P F305

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 June 2013