A fix is available
APAR status
Closed as program error.
Error description
Using DB2 pre-compile option VERSION(AUTO) will allow us to maintain the same collection and plan names. Customers will only need to perform BIND PACKAGE for collections and will not be required to perform a BIND PLAN when we ship new DBRM. This will reduce the need for queue manager quiesces and allow a seamless way to run queue managers at different code levels with respect to code containing executable SQL.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of Websphere MQ for z/OS Version 7 * * Release 0 Modification 1. * **************************************************************** * PROBLEM DESCRIPTION: Implement build change to use the DB2 * * pre-compile VERSION(AUTO) option. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR is raised to implement the build change to exploit the DB2 pre-compile option VERSION(AUTO). This option will cause future DBRM to ship a package version based on a text representation of the DBRM consistency token. This will mean that a BIND PACKAGE of the collection matching the DBRM is all that is needed to add a new package version to the relavent plan when new DBRM is shipped in maintenance. A one time bind of the DB2 application plans is required to bind the collection names into the plans to implement this change following the APPLY of this maintenance. A new CSQ45BPL sample JCL member is shipped with this fix with the updated plan and collection names that will be used to this end.
Problem conclusion
The build change has been implemented and a new sample DB2 BIND PACKAGE JCL called CSQ45BPK is included to tailor and run following future maintenance shipping DBRM. 010Y CSQ45BPK CSQ45BPL CSQ45GEX CSQ5AAUT CSQ5ACHL CSQ5ADOB CSQ5ALOB CSQ5AMSG CSQ5AROB CSQ5ARO2 CSQ5ASCS CSQ5ASSK CSQ5ASTR CSQ5ATOP CSQ5AUOB CSQ5AUTL CSQ5AWOB CSQ5AZAP CSQ5A701 CSQ5B701 CSQ5C701 CSQ5D701 CSQ5K701 CSQ5L701 CSQ5M701 CSQ5PLNA CSQ5PLNB CSQ5PLNC CSQ5PLND CSQ5PLNK CSQ5PLNL CSQ5PLNM CSQ5PLNP CSQ5PLNR CSQ5PLNS CSQ5PLNT CSQ5PLNU CSQ5PLNW CSQ5PLNZ CSQ5PLN2 CSQ5P701 CSQ5R701 CSQ5S701 CSQ5T701 CSQ5U701 CSQ5W701 CSQ5Z701 CSQ52701
Temporary fix
Comments
APAR Information
APAR number
PM65422
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-05-24
Closed date
2012-10-10
Last modified date
2018-12-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK82506
Modules/Macros
CSQ45BPK CSQ45BPL CSQ45GEX CSQ5AAUT CSQ5ACHL CSQ5ADOB CSQ5ALOB CSQ5AMSG CSQ5AROB CSQ5ARO2 CSQ5ASCS CSQ5ASSK CSQ5ASTR CSQ5ATOP CSQ5AUOB CSQ5AUTL CSQ5AWOB CSQ5AZAP CSQ5A701 CSQ5B701 CSQ5C701 CSQ5D701 CSQ5K701 CSQ5L701 CSQ5M701 CSQ5PLNA CSQ5PLNB CSQ5PLNC CSQ5PLND CSQ5PLNK CSQ5PLNL CSQ5PLNM CSQ5PLNP CSQ5PLNR CSQ5PLNS CSQ5PLNT CSQ5PLNU CSQ5PLNW CSQ5PLNZ CSQ5PLN2 CSQ5P701 CSQ5R701 CSQ5S701 CSQ5T701 CSQ5U701 CSQ5W701 CSQ5Z701 CSQ52701
Fix information
Fixed component name
WMQ Z/OS V7
Fixed component ID
5655R3600
Applicable component levels
R010 PSY UK82506
UP12/11/06 P F211
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:
07 December 2018