JR37481: REPLICATION ADMIN FIXES FOR DB2 LUW V97 FP4

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 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