Fixes are available
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as new function.
Error description
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * General defect fix for the FP * **************************************************************** * PROBLEM DESCRIPTION: * * The important fixes are documented to help L2 and customer. * * This has the problem description along with solution. * * * * 1. wsdbu00696518 * * Addess the problem with mass subscriptions while creating * * bidi or p2p subscriptions where not all the tables * * satisfying the predicate in SET TABLES are picked. * * * * 2. wsdbu00811740. * * On Teradata, changed the column name of ROW_NUMBER in table * * IBMQREP_ROLLBACK_R as it is a reserved keyword in Teradata. * * The nickname is altered to ROW_NUMBER so there is no change * * in Q Apply. * * * * 3. wsdbu00824147 * * Changed the output of the CREATE MQ SCRIPT command to make * * it consistent with the script generated by Replication * * Center pdf tool. * * * * 4. wsdbu00695173, wsdbu00823701, 826376 * * Fixed the problem with asntdiff when invoked from java * * program so it can be invoked from dashboard. * * * * 5. wsdbu00701456 * * Do not generate inline statement automatically when lob is * * used. Check if the tablespace supports inline lob statement * * and then generate. * * * * 6. wsdbu00795060 * * Fixed ASN2213E error when multiple create qsub statements * * are present in one input file. * * * * 7. wsdbu00797870 * * Support more than 2 node p2p configuration in CREATE MQ * * SCRIPT command. * * * * 8. wsdbu00798009 * * Add the correct asnclp level while creating control tables. * * * * 9. wsdbu00798352 * * Allow more than 10 lob columns in SQL Replication create * * member. * * * * 10. wsdbu00813163 * * Fixed problem with creating scripts on z.OS with 72 * * character limit. * * * * 11. wsdbu00813528 * * Issue proper error message ASN2425E while creating lower * * level control tables on higher version db2. * * * * 12. wsdbu00814249 * * API not securing the blank space while creating registration * * and member - Puma AG ; germany cust * * * * 13. wsdbu00818069 * * Fix the problem while creating bidi and p2p Q Subscription * * when the source table and target table column names are not * * the same. An error message should be returned instead of * * generating an incorrect script. * * * * 14. wsdbu00793300 * * Fixed the problem "CLI0111E Numeric value out of range when * * calculating alert time from ASN.IBMSNAP_ALERTS" in * * Replication Center. * * * * 15. wsdbu00812828 * * Fixed the problem with update properties of existing Q * * Subscription. Unexpected ASN 2145E returrned when * * expressions are involved. * **************************************************************** * RECOMMENDATION: * * none * ****************************************************************
Problem conclusion
same as description. Problem description includes the solution as well. Dev requested me to close the information with the closing information as update in the problem desc.
Temporary fix
Comments
APAR Information
APAR number
JR37481
Reported component name
WS Q-REPLIC LUW
Reported component ID
5724N9801
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-11
Closed date
2011-05-23
Last modified date
2011-05-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IC72679
Fix information
Fixed component name
WS Q-REPLIC LUW
Fixed component ID
5724N9801
Applicable component levels
R970 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]
Document Information
Modified date:
07 October 2021