IBM Support

Q Replication and SQL Replication APARs in Db2 for Linux, UNIX, and Windows V11.1 Fix Pack 4

Preventive Service Planning


Abstract

The following fixes for Q Replication and SQL Replication are included in Db2 for Linux, UNIX, and Windows V11.1 Fix Pack 4.

Content

JR60276: Q & SQL REPLICATION ADMIN FIXES FOR DB2 V11.1 FP4

  • JR59582: REPLICATION CENTER IN DB2 V11.1 IS ENGLISH ONLY
  • JR59886: LARGER XML OR LOB COLUMN DATA LEFT OUT OF DELIMITED MESSAGES
  • JR59887: CREATE QSUB FAILS FOR STORED PROCEDURE TARGETS WITH DECFLOAT DATA TYPE
  • JR59888: ASNCLP DROP QSUB VERY SLOW WITH LARGE NUMBER OF SUBSCRIPTIONS
  • JR59889: DROP REGISTRATION COMMAND FAILS ON Z/OS
  • JR59890: ASNCLP CANNOT CREATE MEMBER FOR FEDERATED ORACLE TARGET IN SQL REPLICATION


JR60277: Q & SQL REPLICATION ENGINE FIXES FOR DB2 V11.1 FP4

  • JR59173: WHEN TRANS_BATCH_SZ>1, Q REPLICATION USES WRONG COMMITSEQ VALUE FOR TRANSACTIONS TO CCD TABLES
  • JR59267: SQL APPLY ASNLOAD FAILS WHEN USER ID IS GREATER THAN 18 BYTES
  • JR59306: Q APPLY TO ISSUE NEW MESSAGE WHEN PRUNING INTERRUPTED BY STOP COMMAND
  • JR59654: QCAPTURE REQUESTS SAME ARCHIVED LOG FILE MULTIPLE TIMES
  • JR59722: MIGRATION SCRIPT FOR V11.1 FP3 MISSING OLDEST_COMMIT_TIME COLUMN FROM IBMQREP_APPLYMON
  • JR59891: Q APPLY FOR ORACLE ISSUES UNSUPPORTED SELECT STATEMENT AND FAILS
  • JR59893: Q APPLY PROGRAM INCORRECTLY REPORTS MESSAGE GAP
  • JR59894: REPLICATION MONITOR FAILS ON STARTUP IF ALERT MESSAGES EXCEED 32,767
  • JR59896: Q CAPTURE PUBLISHES INCORRECT COMMIT_LSN FOR PARTITIONED DATABASE
  • JR59898: Q REPLICATION PARAMETER ADDED FOR CODE PAGE EXPANSION
  • JR59899: LOADING OF ORACLE STRING DATA FOR REPLICATION CAN FAIL

 

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 November 2018

UID

ibm10740015