IBM Support

Q Replication and SQL Replication APARS in DB2 for Linux, UNIX, and Windows Version 10.5 Fix Pack 9

Preventive Service Planning


Abstract

The following fixes for Q Replication and SQL Replication are included in DB2 for Linux, UNIX, and Windows Version 10.5 Fix Pack 9.

Content

JR58462: Q & SQL REPLICATION ADMIN FIXES FOR DB2 V10.5 FP9

  • JR56712: SCRIPT FOR CREATING SQL REPLICATION CONTROL TABLES ON LINUX, UNIX, AND WINDOWS HAS MULTIPLE ERRORS
  • JR56877: ASNCLP PROGRAM NOT FINDING ADDITIONAL Q CAPTURE SCHEMAS
  • JR57113: ASNCLP PROGRAM FAILS TO CREATE Q SUBSCRIPTION WITH LONG VARCHAR TO VARCHAR AND VICE-VERSA ON Z/OS
  • JR57130: ASNCLP DROP MEMBER AND DROP REGISTRATION FAIL IN V10.5 FP8 AND V11.1
  • JR57158: ASNCLP SET PROFILE COMMAND FAILS WHEN SETTING ABSOLUTE VALUE
  • JR57197: Q SUBSCRIPTION NOT CREATED IF COLUMN NAME CONTAINS "TIME" WITH EXPRESSION
  • JR57411: MISSING SPACE IN AN ASNCLP AND REPLICATION CENTER SCRIPT CAUSES DSNT408I ERROR ON Z/OS
  • JR57509: ASNCLP PROGRAM CAN BE USED TO CREATE Q SUBSCRIPTIONS FOR PROXY CONFIGURATIONS ON Z/OS
  • JR57601: ASNCLP SETS DEFAULT PAGE SIZE TOO LOW FOR REGISTRATION
  • JR57745: ASNCLP NEEDS TO HANDLE ORACLE JDBC BUG THAT RESULTS IN INCORRECT COLUMN LENGTH MATCH
  • JR57750: ASNCLP CANNOT CREATE Q SUBSCRIPTION IF UNIQUE INDEX CONTAINS EXPRESSION
  • JR57965: ASNCLP PROGRAM MISTAKES STRINGS WITH "INT" FOR INTEGER DATA TYPE
  • JR58104: ASNCLP FOR SQL REPLICATION FAILS WITH ASN1560E ON PRE-V10 TARGETS
  • JR58133: ASNCLP FAILS TO CREATE Q SUBSCRIPTION FROM DB2 FOR Z/OS TO NATIVE ORACLE APPLY
  • JR58173: ASNCLP INCORRECTLY REQUIRES SET SERVER COMMANDS TO BE IN PARTICULAR ORDER


JR58463: Q & SQL REPLICATION ENGINE FIXES FOR DB2 V10.5 FP9
  • JR55258: SQL CAPTURE PROGRAM DOES NOT INITIALIZE GLOBAL RECORD WITH CURRENT SYNCH POINT
  • JR55551: Q SUBSCRIPTION STATE REMAINS AS L AFTER FAILURE
  • JR56524: Q APPLY FAILS TO RESTORE INFORMATIONAL CONSTRAINTS ON DB2 FOR LINUX, UNIX, AND WINDOWS TARGETS
  • JR56682: PASSWORD VISIBLE IN ORACLE SQL LOADER OUTPUT
  • JR56683: APPLY INCORRECTLY SKIPS LOADING THE TARGET TABLE
  • JR56684: APPLY PROGRAM HANGS ON INPUT PARAMETER ERROR
  • JR56811: VARCHAR FOR BIT DATA OVER 128 CAUSES INCORRECT CONVERSION OR DUMP IN EVENT PUBLISHING TO LITTLE ENDIAN SYSTEMS
  • JR56812: AUTOMATICALLY GENERATED TABLE-LEVEL Q SUBSCRIPTION MISSING IGNTRIG OPTION
  • JR56837: INEFFICIENT BINDING OF DATE COLUMNS IN ORACLE APPLY CAUSES PERFORMANCE ISSUE
  • JR56841: REMOVE THE NEED TO DROP SECONDARY UNIQUE INDEX OR UNIQUE CONSTRAINTS ON TARGET TABLE DURING QCAPTURE RESTART FROM OLD LSN
  • JR56842: UPDATE FOR MDC TABLE WITH RI CONSTRAINTS ENCOUNTERS RI VIOLATION, SQL CODE -532, ON TARGET SIDE
  • JR56878: Q APPLY FOR NATIVE ORACLE FAILS TO REPLICATE DB2 FOR Z/OS CHAR, VARCHAR FOR BIT DATA, OR MIXED DATA FROM KEY COL W/ EXPRESSION
  • JR57003: REPLICATED UTF-16 DATA IS PRESENTED IN REVERSE ON LITTLE ENDIAN PLATFORMS
  • JR57004: INCORRECT CHARSET HANDING FOR JA16SJIS IN Q APPLY
  • JR57086: Q APPLY PROGRAM FAILS TO STOP AFTER "KILL DB2SYSC" COMMAND WITH TERM=Y
  • JR57157: MQ LOG CAN FILL WHEN Q APPLY LEAVES MESSAGE DELETES UNCOMMITTED
  • JR57168: Q APPLY INCORRECTLY REPORTS DUPLICATE ROW ERRORS FOR CONDENSED, COMPLETE CCDS
  • JR57203: Q APPLY USES ORACLE SQL LOADER TO HANDLE EXPRESSIONS WHEN LOADING DATA FROM SOURCE TO ORACLE TARGET
  • JR57231: RACES BETWEEN THREADS CAN PREVENT Q APPLY FROM RESTARTING CORRECTLY WHEN PARALLEL_SENDQS=Y
  • JR57364: MIGRATION SCRIPT FOR FEDERATED ORACLE TARGETS IS MISSING STEPS FOR NICKNAME ALTERATIONS
  • JR57410: MULTI-ROW INSERT FOR NVARCHAR2 FAILS FOR NATIVE ORACLE TARGETS FROM Z/OS
  • JR57569: BLANK SOURCE GRAPHIC COLUMNS INCORRECTLY CHANGED TO NULL ON ORACLE TARGETS
  • JR57538: SUBSCRIPTION-SET MEMBER TYPE CAUSES ERRORS FOR TABLE COMPARE UTILITY
  • JR57656: SQL REPLICATION SYNCHTIME VALUE UNNECESSARILY UPDATED
  • JR57657: Q REPLICATION PROGRAMS STOP WHEN SCHEMA SUBSCRIPTION IS DELETED BEFORE ACTIVATION
  • JR57669: REPLICATION ALERT MONITOR NOW SUPPORTS NATIVE ORACLE TARGETS
  • JR57698: FOR ORACLE RAC REPLICATION TARGETS, TERM=N SOMETIMES NOT RESPECTED
  • JR57719: TRAILING BLANKS INCORRECTLY ADDED FROM DB2 FOR Z/OS SOURCE GRAPHIC TO ORACLE TARGET VARCHAR2 OR CHAR DURING INTERNAL LOAD
  • JR57878: APPLY PROGRAM DEACTIVATES SUBSCRIPTION SET INCORRECTLY
  • JR57966: DIAGNOSTIC TRACE MESSAGE MIGHT EXCEED LENGTH LIMIT WITH EXPANSION FROM CODE PAGE CONVERSION
  • JR57970: Q APPLY FAILS TO READ OR UPDATE COLUMNS CORRECTLY IN Q-SQL REPLICATION FAN-OUT CONFIGURATION
  • JR58058: REPLICATION MONITOR PROGRAM ENABLED TO WRITE ALERT MESSAGES TO FILES
  • JR58174: Q APPLY SPILL QUEUE PROCESSING SLOW WHEN RESOLVING SECONDARY UNIQUE CONSTRAINT VIOLATION(S)
  • JR58175: PARAMETER ADDED TO IMPROVE PERFORMANCE OF NATIVE ORACLE LOADS
  • JR58183: APPLY PROGRAM FAILS WHEN REPLICATING LOB TO NONCONDENSED CCD TABLE
  • JR58189: NEW ENVIRONMENT VARIABLE ENABLES DB2 CORE DUMPS FOR Q REPLICATION
  • JR58190: INITIAL VALUES OF SYNCHPOINT AND CCD_OLD_SYNCHPOINT IN IBMSNAP_REGISTER INCORRECTLY SET
  • JR58236: BIDIRECTIONAL Q SUBSCRIPTION STATES INCORRECT WHEN LOADING FAILS
  • JR58334: QCAPTURE INCORRECTLY SETS 'LAST MESSAGE IN DB TRANSACTION' FLAG FOR LARGE MULTI-MESSAGE TRANSACTION WITH SEPARATE LOBS
  • JR58385: Q APPLY FOR ORACLE RESPONDS INCORRECTLY WHEN LOAD FAILS

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

Document Information

Modified date:
16 June 2018

UID

swg22008709

Page Feedback