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 WebSphere MQ for z/OS Version 7 * * Release 1 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: * **************************************************************** 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. 100Y CSQERRPB
Temporary fix
Comments
APAR Information
APAR number
PI59471
Reported component name
WMQ Z/OS V7
Reported component ID
5655R3600
Reported release
100
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-03-21
Closed date
2016-07-28
Last modified date
2016-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CSQERRPB
Fix information
Fixed component name
WMQ Z/OS V7
Fixed component ID
5655R3600
Applicable component levels
R100 PSY UI39742
UP16/08/25 P F608
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.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 September 2016