A fix is available
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:
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":"LOB45","label":"Automation"}}]
Document Information
Modified date:
02 November 2016