IBM Support

PI65854: WMQ BACKUP CFSTRUCT FAILS WITH CSQ5023E AND CSQ5009E

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • BACKUP CFSTRUCT on DR system fails with
    CSQ5023E  CSQ5LMSG SQL error, failed to
    access table CSQ.ADMIN_B_MESSAGES
    
    CSQ5009E CSQ5LMSG SQL error for table
     CSQ.ADMIN_B_MESSAGES, code=-904 state=57011,
        data=-661 00C9000A
        00000000 00000000 00000000
    CSQE106E CSQELBK1 Unable to backup structure
     EPS, reason=00F5001C
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of IBM MQ for z/OS Version 9 Release 0             *
    * Modification 0                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After DB2 has recovered CSQ.ADMIN_B_MESSAGES, the message    *
    * blob data may not be automatically recovered by DB2. When MQ *
    * CF Structure recovery is initiated, the message blob data    *
    * may not be recovered if entries exist in the                 *
    * CSQ.ADMIN_B_MESSAGES table, this then can result in CSQ5009E *
    * with error code -904 when attempting to get the message or   *
    * backup the structure.                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * N/A                                                          *
    ****************************************************************
    When DB2 offload is used on a CF structure and messages have
    been offloaded, if the tables are recovered by DB2,
    CSQ.ADMIN_B_MESSAGES is recovered however the auxiliary tables
    for the blob data (CSQ.ADMIN_MSGS_BAUXn) are not as they are
    defined with LOG NO.
    
    This is expected, however in this case, when CF structure
    recovery attempts to replay the messages into the table, an SQL
    error occurs (-803) due to the row for the message already
    existing in the table. This results in the message not being
    replaced in the table with the correct message data.
    
    Attempting to browse or get messages from an affected queue
    fails with MQRC 2342 (MQRC_DB2_NOT_AVAILABLE), and BACKUP
    CFSTRUCT commands fail with CSQE106E with reason=00F5001C
    (CSQ5_DB2_UNAVAILABLE). The queue manager will also show message
    CSQ5023E, with SQL error code=-904.
    

Problem conclusion

  • CF structure recovery processing has been updated to cope with
    blob data not being recovered with the rest of the DB2 tables.
    The processing now clears the CSQ.ADMIN_B_MESSAGES data for a
    structure prior to replaying the messages, correctly inserting
    the message data into the table.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI65854

  • Reported component name

    MQ Z/OS V9

  • Reported component ID

    5655MQ900

  • Reported release

    000

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-14

  • Closed date

    2016-09-30

  • Last modified date

    2016-11-02

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

    PI59471

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

    UI41301

Modules/Macros

  • CSQERRPB
    

Fix information

  • Fixed component name

    MQ Z/OS V9

  • Fixed component ID

    5655MQ900

Applicable component levels

  • R000 PSY UI41301

       UP16/10/14 P F610

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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSYHRD","label":"IBM MQ"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
02 November 2016