IBM Support

IIDR 11.3.3 Replication Engines for Linux, Unix and Windows - Patches

Fix Readme


Abstract

InfoSphere Data Replication 11.3.3 Replication Engine patches

Content

September 15, 2021

IDR 11.3.3.3-123

Enhancements in IDR 11.3.3.3-123

IDR 11.3.3.3-123 for all LUW engines

  • Updated the Java virtual machine to IBM 8.0.6.30
December 4, 2020

IDR 11.3.3.3-118

APARs in IDR 11.3.3.3-118

IDR 11.3.3.3-118 for all LUW engines

  • JR62985 IDR IS NOT POPULATING JCF FIELDS FOR START AND END REFRESH EVENTS WHEN USEREXIT USED
July 22, 2020

IDR 11.3.3.3-115

APARs in IDR 11.3.3.3-115

IDR 11.3.3.3-115 for Sybase

  • JR62543 CDC FOR Sybase INSTANCE MAY FAIL TO START DUE TO "RECORD FOR CHECKPOINT NOT FOUND" ERROR
June 25, 2020

IDR 11.3.3.3-113

Enhancements in IDR 11.3.3.3-113

IDR 11.3.3.3-113 for all LUW engines

  • Java Runtime Environment updated from IBM Java 8.0.6.0 to 8.0.6.10. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/

APARs in IDR 11.3.3.3-113

IDR 11.3.3.3-113 for Sybase

  • JR62380 IIDR Sybase DMSUPPORTINFO COMMAND MAY COLLECT THE DB USERNAME AND PASSWORD IN PLAINTEXT
May 22, 2020

IDR LUW 11.3.3.3-109

Enhancements in IDR LUW 11.3.3.3-109

IDR LUW 11.3.3.3-109 for all LUW engines

  • Java Runtime Environment updated from IBM Java 8.0.5.41 to 8.0.6.0. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/

IDR LUW 11.3.3.3-109 for Sybase

  • Update DataDirect JDBC driver for Sybase to 5.1.4.000128. The new jdbc driver has added enhancement to allow jdbc connection to Sybase Adaptive Server Enterprise configured with server option "net password encryption requd" set to 1 and above (acceptable values from 0 to 2)

APARs in IDR LUW 11.3.3.3-109

IDR LUW 11.3.3.3-109 for Sybase

  • JR62300 DMSUPPORTINFO COMMAND FOR IIDR 11.3.3.3 Sybase RETURNS NULL.

IIDR 11.3.3.3-101 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-101 for Oracle JR61775 IMPROVE THE HANDLING OF COLUMNS WITH DEFAULT CLAUSES.

Here is the link to the Fix Central page:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-99 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-99 for all LUW engines
JR61177 WHEN USING CONFLICT RESOLUTION OR ADAPTIVE APPLY AND MAPPING TO DATABASE DEFAULT, NOT NULL COLUMNS ARE ENTERED AS NULL.

IIDR 11.3.3.3-99 for Event Server
JR60041 - Drop stagedb table when table mapping is deleted

Here is the link to the Fix Central page:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-93 for all LUW engines

IIDR 11.3.3.3-93 for all LUW engines is available on FixCentral.
Updated JVMs for AIX, Windows, Linux x64, Linux Power and Linux s390 to IBM JRE 8.0.5.26.

IIDR 11.3.3.3-93 for Db2 for Linux, UNIX and Windows
JR60769 UPGRADE FROM 10.2.1 TO 11.3.3GA FAILS WITH NUMBERFORMATEXCEPTION

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-92 for all LUW engines

IIDR 11.3.3.3-92 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-92 for Oracle
JR60677 CDC IS GETTING ARRAYINDEXOUTOFBOUNDEXCEPTION IN LOGREADER AND WHICH IS BRINGING SUBSCRIPTION DOWN.

IIDR 11.3.3.3-92 for Sybase
JR60627 IIDR Sybase SUBSCRIPTIONS CAN FAIL WHEN ATTEMPTING TO IDENTIFY HEAD OF LOG POSITION

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-90 for all LUW engines

IIDR 11.3.3.3-90 for all LUW engines is available on FixCentral.

JR60468 IIDR FAILS WITH EXCEPTION 'CANNOT INSERT VALUE NULL' WHEN PROCESSING TABLE LEVEL AUDIT MESSAGES

IIDR 11.3.3.3-90 for Informix
Add support for database object identifier qualification in Informix

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-85 for all LUW engines

IIDR 11.3.3.3-85 for all LUW engines is available on FixCentral.
JR60275 NON-EMPTY BLOB DATA IS BEING REPLICATED AS EMPTY BLOB DATA

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-84 for all LUW engines

IIDR 11.3.3.3-84 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-84 for Oracle
JR60125 CDC ONLY ADDS ONE ENTRY TO THE CACHE LIST, IF WE HAVE MULTIPLE DESTINATIONS

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-83 for all LUW engines

IIDR 11.3.3.3-83 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-83 for Oracle
JR59805 IIDR FOR ORACLE 11.3.3.3 MIRRORING ENDS WITH INCORRECTLY IDENTIFYING A SUSPECTED DDL CHANGE ON THE REPORTED TABLE.

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-82 for all LUW engines

IIDR 11.3.3.3-82 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-82 for Informix
JR59995 UNEXPECTEDQUERYRESULTNECESSITYEXCEPTION ENCOUNTERED DURING CDC INFORMIX INSTANCE CREATION

IIDR 11.3.3.3-82 for Oracle
JR59187 OUT OF MEMORY ERROR POSSIBLE IF ISERIES SOURCE REORGS TABLES MANY TIMES SINCE A SUBSCRIPTION STARTS RUNNING.
JR59805 IIDR FOR ORACLE 11.3.3.3 MIRRORING ENDS WITH INCORRECTLY IDENTIFYING A SUSPECTED DDL CHANGE ON THE REPORTED TABLE.

IIDR 11.3.3.3-82 for Microsoft SQLServer, Oracle and Sybase
JR59762 MEMORY AND FILE LEAK FOR A TABLE WITH MORE THAN ONE CLOB/LOB COLUMNS

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-81 for all LUW engines

IIDR 11.3.3.3-81 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-81 for Db2 LUW
JR59346 THE NPE HAPPENS WHEN THE LOB RECORDS ARE COMING BEFORE THE DMS RECORDS.

IIDR 11.3.3.3-81 for Oracle
JR57452 COMMITS ARE FILLING UP ASM AUDIT TRACES BECAUSE OF DEFAULT AUTOCOMMIT SETTING ON ORACLE EXADATA.

Here is the link to FixCentral:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all 

IIDR 11.3.3.3-80 for all LUW engines

IIDR 11.3.3.3-80 for all LUW engines is available on FixCentral.

JR59352 JAVA.LANG.ASSERTIONERROR: UNABLE TO UNLOCK JDBC DRIVER, AFTER MIGRATION FROM 11.3.3-GA
A SUBSCRIPTION WITH A DERIVED EXPRESSION CONTAINING MORE THAN ONE REFERENCE TO THE SAME JOURNAL CONTROL FIELD FAILS WITH EVALUATIONFATALEXCEPTION (STRINGINDEXOUTOFBOUNDEXCEPTION)

IIDR 11.3.3.3-80 for Oracle
JR58954 CHOOSE THE MINIMUM RESTART POSITION AND THE MINIMUM COMMIT+CURRENT INDEPENDENTLY FOR GROUP START

Here is the link to download:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all 

IIDR 11.3.3.3-78 for all LUW Engines

IIDR 11.3.3.3-78 for all LUW Engines is available on FixCentral.

IIDR 11.3.3.3-78 for Netezza
JR57213 DMREASSIGNTABLE TABLE COMMAND IS MISSING FOR CDC NETEZZA
JR59182 STUCK BOOKMARK: CDC FOR NETEZZA COMMIT CAN BE DELAYED INDEFINITELY WHEN APPLY IS BUSY

IIDR 11.3.3.3-78 for Oracle
JR58339 EVENT LOG FLOODED WITH XA TRANSACTION MESSAGE

Here is the link to download:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-76 for all LUW Engines

IIDR 11.3.3.3-76 for all LUW Engines is available on FixCentral.

IIDR 11.3.3.3-76 for all LUW Engines
JR59134 IDR/CDC UTILITY COMMANDS CAN RUN SLOWLY IF THERE ARE MANY UTILITY TRACE FILES IN THE INSTANCE LOG DIRECTORY
IIDR 11.3.3.3-76 for Netezza
JR59146 IIDR CDC FOR NETEZZA CAN NOT FIND PRIMARY KEY FOR MULTI SCHEMA CONFIG

Here is the link to download:
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3.3&platform=All&function=all

IIDR 11.3.3.3-74 for all LUW Engines

IIDR 11.3.3.3-74 for all LUW Engines is available on FixCentral.

IIDR 11.3.3.3-74 for Informix
JR59114 CANNOT CREATE A SOURCE INSTANCE FOR IIDR FOR INFORMIX 11.3.3

IIDR 11.3.3.3-74 for Microsoft SqlServer
JR59139 EXCEPTION PERSISTING THE TRANSACTION QUEUE

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-73 for all LUW engines

IIDR 11.3.3.3-73 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-73 for Sybase
JR58876 IIDR FOR Sybase CAN REPORT A LOG HOLE WHEN THE TRUNCATION PAGE FOR A LOG DUMP IS LESS THAN THE FIRST PAGE .

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-71 for all LUW Engines

IIDR 11.3.3.3-71 for all LUW Engines is available on FixCentral

IIDR 11.3.3.3-71 for Db2
JR58736 CDC FOR DB2 INSTANCE WITH A LOWERCASE SCHEMA NAME FAILS TO START WHEN CDC IS UPGRADED FROM 10.2.1 TO 11.3.3 GA

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-70 for all LUW Engines

IIDR 11.3.3.3-70 for all LUW Engines is available on FixCentral.

IIDR 11.3.3.3-70 for Sybase
JR58842 IIDR FOR Sybase INCORRECTLY REPORTS A LOG DUMP AS INVALID (NOT A LOG DUMP).

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-69 for all LUW engines

IIDR 11.3.3.3-69 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-69 for Sybase
JR58606 IIDR FOR Sybase UNABLE TO RETREIVE BOOKMARK WHEN MAPPING TABLES.

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-67 for all LUW engines

IIDR 11.3.3.3-67 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-67 for Db2 LUW
JR58500 THE SUBSCRIPTION FAILED BECAUSE THE CONFLICT HAPPENED BUT CDC CAN NOT RESOLVE IT.

IIDR 11.3.3.3-67 for Teradata
JR58590 DIFFERENTIAL REFRESH WITH 'ONLY LOG DIFFERENCES' MODE FAILS WITH 'FAILED TO ADD A ROW TO TABLE XXXXXX......'

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-66 for all LUW engines

IIDR 11.3.3.3-66 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-66 for Oracle
JR58247 IIDR ORACLE AGENT FAILS TO IDENTIFY RESTORED ARCHIVE LOGS.
JR58448 REQUESTED TO REMOVE A UOW THAT WAS NOT THE ACTIVE UOW
JR58464 SUBSCRIPTIONS IN ARCHIVED_LOG_ONLY MODE NOT FAILING WHEN REQUIRED ARCHIVE LOGS DO NOT EXIST.

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-65 for all LUW Engines

IIDR 11.3.3.3-65 for all LUW engines is available on FixCentral.
JR58009 MISSING ROWS AND DATA MISMATCH AS A RESULT OF TRANSACTION ROLLBACK

JR58086 CDC ISSUES JAVA.LANG.NULLPOINTEREXCEPTION WHEN CDC TRIES TO UPDATE A LOB VALUE AND THE CONFLICT CONDITION IS HIT.

IIDR 11.3.3.3-65 for Teradata
JR58320 TERADATA FASTLOAD DATA FILE IS CORRUPTED WHEN TARGET TABLE HAS COLUMNS MAPPED TO DATABASE DEFAULT VALUE

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-64 for all LUW Engines

IIDR 11.3.3.3-64 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-64 for DB2 LUW
JR57340 UNABLE TO UPGRADE TO IIDR 11.3.3.3 IF 44 AND ABOVE DUE TO BOOKMARK FORMAT CHANGES.

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-63 for all LUW engines

IIDR 11.3.3.3-63 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-63 for Event Server
JR57025 CDC 11.3.3 FOR EVENT SERVER AS TARGET GOT FAILURE WHEN IT REPLICATED TRUNCATE OPERATION.

IIDR 11.3.3.3-63 for Netezza
JR57030 CDC NETEZZA RUNS OUT OF MEMORY WHEN NETEZZA LOAD PROCESS HANGS OR TAKING VERY LONG TIME

IIDR 11.3.3.3-63 for Oracle
JR57438 DMSHOWLOGDEPENDENCY IS THROWING EXCEPTION WITH -L OPTION
JR57440 EXCEPTION AT CONTINUE READING ERROR 'ROW ALREADY EXIST IN INDEX TS_ORACLE_ARCHIVES_PK ON TABLE TS_ORACLE_ARCHIVES'
JR57469 REPLICATION STOPS WITH ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN PARSING OVERFLOW RECORD FOR A TABLE THAT HAS LOB COLUMNS.
JR57477 DMSHOWLOGDEPENDENCY COMMAND RETURNS 'NULL' IN CASE OF LOG SHIPPING WITH DATAGUARD SETUP.

IIDR 11.3.3.3-63 for Sybase
JR57546 IIDR CDC Sybase LOOPS FOR CERTAIN Sybase LOGS

Here is the link to the FixCentral page:

http://www.ibm.com/support/fixcentral/swg/quickorder?product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-62 for all LUW Engines

IIDR 11.3.3.3-62 for all LUW Engines is available on FixCentral

JR57266 TAKING A TRANSACTION QUEUE SNAPSHOT FAILS WITH 'EXCEPTION CREATING THE TABLES IN THE TRANSACTION QUEUE DB'

IIDR 11.3.3.3-62 for Oracle
JR56917 'UNEXPECTED PARSING ERROR FOR TABLE' WHEN CDC WAS TRYING TO PARSE AN UPDATE OPERATION CAUSING SUBSCRIPTION TO ABORT.

IIDR 11.3.3.3-62 for Sybase
JR57357 CDC FOR Sybase UNABLE TO GET BOOKMARK

Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-60 for all LUW engines

IIDR 11.3.3.3-60 for Netezza
JR57240 ADD ABILITY TO CONTROL FREQUENCY OF BOOKMARK TABLE UPDATE ON REPORT POSITION MESSAGE.

IIDR 11.3.3.3-59 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-59 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-59 for Oracle
JR57167 IIDR FAILS TO START, WITH INVALID PARAMETER BINDING ERROR.
JR57162 IIDR IS NOT ABLE TO GET NEXT ONLINE LOG FILE TO READ WHEN PRODUCT IS CONFIGURED TO READ FROM ORACLE RAC SYSTEM.

Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-58 for all LUW engines

IIDR 11.3.3.3-58 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-58 for Oracle
* JR57085 CDC IS NOT PROCESSING ANY FILE IN MANUAL LOG SHIPPING WHEN FILE IS DELETED FROM ORIGINAL LOCATION
* JR56720 UPDATE IS FAILING WITH ERROR ORA-01407 WHEN COLUMN IS DEFINED AS NOT NULL WITH DATABASE DEFAULT VALUE
* JR57125 DMSHOWLOGDEPENDENCY COMMAND CAN RETURN COMPLETED LOGS IN THE REQUIRED LOG LIST AS NOT AVAILABLE, MISSING
* JR57120 DMSHOWLOGDEPENDENCY CAN RETURN A NULL POINTER EXCEPTION
* JR57121 DMSHOWLOGDEPENDENCY DOES NOT RETURN THE FULL LIST OF REQUIRED LOGS

Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc
 

IIDR 11.3.3.3-56 for all LUW engines

IIDR 11.3.3.3-56 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-56 for Oracle
* JR57074 CDC for Oracle fails with 'row already exist in index TS_ORACLE_ARCHIVES_PK' when using manual log shipping

Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-55 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-55 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-55 for LUW engines
* JR56727 PERFORM UPDATE WOULD THROW EVALUATIONFATALEXCEPTION WHEN USING&***(journal control field) AS DERIVED EXPRESSION IN COLUMN MAPPING.
* JR56843 NULLPOINTEREXCEPTION WHEN SOME SOURCE COLUMNS ARE NOT MAPPED TO TARGET AND HAVE BAD DATA.
* JR56954 MOUNT POINT OVERRIDE NOT TAKING EFFECT
* JR56963 IIDR/CDC SUBSCRIPTION FAILS WITH CHC9696E ERROR

IIDR 11.3.3.3-55 for Oracle
* JR56674 REPLICATION IS NOT HAPPENING IN MANUAL LOG SHIPPING WHEN DEST_ID VALUE IS DIFFERENT THAN 1 .
* JR56660 ERROR ORA-12154 COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED ON STARTUP
* JR56764 IIDR ASKS FOR ORACLE ASM CREDENTIALS DUE TO NON-MULTIPLEXEDGROUP ASM MANAGED LOGS OF STANDBY TYPE
* JR56959 DMSHOWLOGDEPENDENCY REPORTS FILES MISSING UNDER MANUAL LOG SHIPPING
* JR56720 UPDATE IS FAILING WITH ERROR ORA-01407 WHEN COLUMN IS DEFINED ASNOT NULL WITH DATABASE DEFAULT VALUE
* dmarchivelogavailable and dmarchivelogremove commands are enhanced to allow user to provide threadid and sequence key information

Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-50 for all LUW engines is available on FixCentral

IIDR 11.3.3.3-50 for all LUW engines is available on FixCentral.
IIDR 11.3.3.3-50 for LUW engines
* Extended test period for early program license

IIDR 11.3.3.3-50 for DB2 LUW
* JR56193 CDC IS INCORRECTLY MAPPING THE SQL OPERATION TYPE FOR FEW UNKNOWN/UNEXPECTED DATABASE OPERATIONS
* JR56451 IIDR 10.2.1/11.3.3 REPORTS NEGATIVE COUNT OF TARGET ROWS AFTER REFRESH WITH NUMBERS LARGER THAN INT MAXIMUM VALUE

IIDR 11.3.3.3-50 for Sybase
* JR56590 UNABLE TO CREATE INSTANCE FOR CDC FOR Sybase: 'IBM INFOSPHERE DATA REPLICATION CAN NOT WRITE TO DIRECTORY'
Here is the generated link to the Fix Central page.

IIDR 11.3.3.3-49 for all LUW engines

IIDR 11.3.3.3-49 for all LUW engines is available on FixCentral.
IIDR 11.3.3.3-49 for all LUW engines
* JR56457 IT IS UNABLE TO GET EVENTS WITH DMSHOWEVENTS COMMAND
* JR56614 PERSISTENT SUBSCRIPTION MONITOR CAUSES METADATA DEADLOCK

IIDR 11.3.3.3-49 for Microsoft SqlServer
* JR56594 LOG READER STARTS LOOPING, IF GARBAGE DATA IS FOUND IN THE CURRENT SECTOR FROM TRANSACTION LOG BACKUP

IIDR 11.3.3.3-49 for Sybase
* JR56590 UNABLE TO CREATE INSTANCE FOR CDC FOR Sybase: 'IBM INFOSPHERE DATA REPLICATION CAN NOT WRITE TO DIRECTORY'
 

Here is the link to the Fix Central page:

http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-47 for all LUW engines can be found on Fix Central

IIDR 11.3.3.3-47 for all LUW engines can be found on Fix Central.
* Enhanced collection of file system characteristics in dmsupportinfo
* JR56205 'CURRENT TIMESTAMP' & 'CONSTANTS' ARE NOT BEING POPULATED IN AUDIT MAPPING TYPE FOR THE 'CLRPFM' AND 'STRJRNPF' COMMANDS.

IIDR 11.3.3.3-47 for DB2 LUW
* JR52335 CDC IS UNABLE TO DETECT ADD PARTITION DDL AND HENCE UNABLE TO REPLICATE ANY CHANGES FROM THE NEWLY ADDED PARTITION.

IIDR 11.3.3.3-47 for Microsoft SqlServer
* Improved memory management when refreshing large tables

IIDR 11.3.3.3-47 for Oracle
* JR56290 DMSHOWLOGDEPENDENCY WITH -L OPTION RETURNS NULL

Here is the link to the Fix Central page:

http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc

IIDR 11.3.3.3-46 for all LUW engines can be found on Fix Central

IIDR 11.3.3.3-46 for all LUW engines can be found on Fix Central.

IIDR 11.3.3.3-46 for Microsoft SQL Server
APAR
JR56275 IIDR CDC WILL STOP WITH A NECESSITY EXCEPTION THAT REPORT_POSITION_ID IS BEFORE BOOKMARK

IIDR 11.3.3.3-45 for all engines can be found on Fix Central.

IIDR 11.3.3.3-45 for all engines can be found on Fix Central.


IIDR 11.3.3.3-45 for Oracle
JR55859 IIDR fails with ORA-04030 error when refreshing a table with XMLType column which has BINARY as storage option
JR56384 dmarchivelogavailable and dmarchivelogremove return errors that null value is not allowed or log to deregister is not valid

IIDR 11.3.3.3-44 for all LUW engines is available on FixCentral.

IIDR 11.3.3.3-44 for all engines can be found on Fix Central.

IIDR 11.3.3.3-44 for DB2 LUW
* Modify Purescale transaction ordering logic from VTS based ordering to one based on LFS and LSN.

Note: Deployments of IIDR for DB2 LUW on PureScale should avoid DDL changes during the upgrade steps. Otherwise this will require completing the DDL procedure prior to upgrading to this version of IIDR CDC for DB2 LUW.

IIDR 11.3.3.3-44 for Event Server
JR56064 WHEN REFRESHING/MIRRORING DATA TO A EVENT SERVER MQ TARGET, THE XML MESSAGE DATA SHOULD CONTAIN A TAG FOR THE TABLE NAME.

IIDR 11.3.3.3-44 for Netezza
JR55991 NETEZZA: ERROR RETURNED WHEN MAPPING A TABLE IN A MULTI-SCHEMA DATABASE.

IIDR 11.3.3.3-44 for Oracle
JR56199 UNABLE TO INSERT DELETE OPERATION ON TARGET ORACLE AUDIT TABLE( INVALID PARM BINDING), WHEN LOB DATATYPE IS USED.
JR56205 'CURRENT TIMESTAMP' & 'CONSTANTS' ARE NOT BEING POPULATED IN AUDIT MAPPING TYPE FOR THE 'CLRPFM' AND 'STRJRNPF' COMMANDS.
JR56265 UPDATES ARE NOT GETTING REPLICATED PROPERLY FOR PARTITION COMPRESSED TABLE

IIDR 11.3.3.3-44 for Sybase
JR56044 Sybase DB LOGS ERROR WHEN DMGETSUBSCRIPTIONSTATUS IS EXECUTED

IIDR 11.3.3.3-42 for all LUW engines can be found on Fix Central

IIDR 11.3.3.3-42 for all engines can be found on Fix Central.
APARs
JR55791 REFRESH TABLES USING JOURNAL CONTROL FIELD @CNTRRN FAILS WHEN CDC FOR DB2 FOR IBM I IS SOURCE

IIDR 11.3.3.3-42 for Oracle
APARs
JR55951 ORACLE MERGE STATEMENT HANDLING WHEN A MERGE INCLUDES UPDATE WITH DELETE

IIDR 11.3.3.3-40 for all LUW engines can be found on Fix Central

IIDR 11.3.3.3-40 for all engines can be found on Fix Central.
APAR
JR55889 FILE HANDLE LEAK WHEN REPLICATING CLOB DATA THAT IS READ FROM DB AND REQUIRES ENCODING CONVERSION.

IIDR 11.3.3.3-39 for all LUW engines can be found on Fix Central

IIDR 11.3.3.3-39 for all engines can be found on Fix Central.
JR55631 UPDATE FAILURE WHEN 'MINIMIZE NETWORK LOAD' ENABLED
JR55714 EXPLICIT ENCODING CONVERSION DOESN'T WORK WITH CDC FOR DB2 FOR IBM I
JR55795 DIFFERENTIAL REFRESH FAILS WITH 'NO ROWS WERE FOUND'

IIDR 11.3.3.3-39 for Event Server
JR55517 INCORRECT VALUES IN EVENT MESSAGE FOR RECORDS RECEIVED AND APPLIED AT THE END OF REFRESH
 

IIDR 11.3.3.3-36 for all engines can be found on Fix Central

IIDR 11.3.3.3-36 for Oracle
APARs:
JR55509 UPDATES ARE NOT GETTING REPLICATED PROPERLY IN CASE OF PARTITION COMPRESSED TABLE.

IIDR 11.3.3.3-32 for all engines can be found on Fix Central

APARs
JR55216 COMMAND DMMARKTABLECAPTUREPOINT WORKS ONLY FOR ONE SUBSCRIPTION

IIDR 11.3.3.3-32 for DataStage
* Improved socket exception handling for Hadoop

IIDR 11.3.3.3-32 for DB2 LUW
APARs
JR55525 REPLICATION OF A TABLE FAILS FROM ISERIES TO IIDR 11.3.3.2 DB2 LUW WHEN TABLE CONTAINS OVERRIDDEN COLUMNS

IIDR 11.3.3.3-32 for Oracle
APARs
JR55286 ADAPTIVE APPLY MAPPING OF CDC RESULTS IN ADDITIONAL UPDATE OPERATIONS WHEN REPLICATION KEYS ARE SET TO AUTO-DETECT

IIDR 11.3.3.3-32 for Sybase
APARs
JR55497 NUMERIC OVERFLOW ERROR WHILE CREATING SUBSCRIPTION WHEN USING Sybase SDK 16.0.

IIDR 11.3.3.3-32 for Teradata
APARs
JR55550 REFRESH FAILS WHEN TABLE MAPPING INCLUDES TIME(0) COLUMN

IIDR 11.3.3.3-31 for all LUW engines can be found on Fix Central

IIDR 11.3.3.3 for all engines can be found on Fix Central.

IIDR 11.3.3.3-31 for Teradata
APARs
JR55549 TERADATA VERSION CHECKING IS TOO RESTRICTIVE

IIDR 11.3.3.3-27 for LUW engines can be found on Fix Central

IIDR 11.3.3.3-27 for all LUW engines (other than Power Linux) can be found on Fix Central

* Improved performance for fast apply

IIDR 11.3.3.3-27 for DataStage
* Added ability to configure the write cache size for WebHDFS mappings using hdfs_write_cache_mb

APAR's:
JR54413 CORRECT SETJRNPOS' BEHAVIOUR IN A I->DS DIRECT CONNECT SUBSCRIPTION
JR54993 RECORD COUNT NOT INCLUDED IN FLAT FILE NAME IN IIDR V11.3.3.X
JR55398 IIDR FOR DATASTAGE 11.3.3 DIRECT CONNECT SUBSCRIPTIONS DO NOT AUTOSTART DATASTAGE JOBS WHEN REFRESH/MIRRORING STARTS.

IIDR 11.3.3.3-27 for DB2 LUW
JR55278 WHEN RUNNING A REFRESH USING TIMESTAMP COLUMNS, THE TARGET DB2 SENDS LOTS OF SQL3125W WARNINGS

IIDR 11.3.3.3-27 for Oracle
JR54995 WITH AN ORACLE SOURCE, THE AFTER IMAGE SENT TO THE TARGET IS DIFFERENT FROM THE ACTUAL SOURCE VALUE
JR55186 SUBSCRIPTION MAY FAIL WITH ERROR: INDEXOUTOFBOUNDSEXCEPTION INDEX: -52000, SIZE: 2000 WHEN USING ASM

IIDR 11.3.3.3-27 for SqlServer
* The engine now checks whether the SqlServer version is supported.
* Improved handling of scraping logs while a backup is in progress

IIDR 11.3.3.3-27 for Sybase
JR55363 Sybase DB LOGS ERROR WHEN DMGETSUBSCRIPTIONSTATUS IS EXECUTED

IIDR 11.3.3.3-5358 for Management Console and Access Server can be found on Fix Central.
* Support for the IIDR 11.3.3.3 LUW engines.

APAR:
JR55433 IMPORT SUBSCRIPTION FROM CHCCLP RETURNS ÝERR2324

IIDR 11.3.3.2-25 for all LUW engines can be found on Fix Central.

APARs:
JR54946 IF SMTP SERVER IS NOT CONFIGURED PROPERLY, IIDR CAN BE UNRESPONSIVE
JR55016 DMSET COMMAND RETURNS ERROR WHEN RUN ON IIDR LUW 11.3.3.2_RELEASE 19

IIDR 11.3.3.2-25 for Netezza
APARs:
JR54816 TRUNCATE WHEN CONFIGURED WITH 'ON CLEAR/TRUNCATE ==>DO NOT DELETE' IS NOT WORKING AS EXPECTED IN NETEZZA ENGINE

IIDR 11.3.3.2-25 for DataStage
APARs:
JR55037 THE INFOSPHERE DATASTAGE PROPERTIES ROW THRESHOLD VALUE IS NOT BEING APPLIED DURING REFRESH TO DATASTAGE TARGETS

IIDR 11.3.3.2-25 for Oracle
* IIDR for Oracle now supports the timezone conversion derived expression %TODIFFERENTTIMEZONE
APARs:
JR55111 SUBSCRIPTION FAILS AFTER CERTAIN DDLS ARE EXECUTED IN ORACLE
JR54995 WITH AN ORACLE SOURCE, THE AFTER IMAGE SENT TO THE TARGET IS DIFFERENT FROM THE ACTUAL SOURCE VALUE
JR55079 IIDR CDC FOR ORACLE 12C FAILED TO RETRIEVE TABLE STRUCTURE FOR TABLE WHEN MC WAS LOADING TABLE MAPPING DETAILS
JR54985 ROLLED BACK INSERTS IN ORACLE CAN BE SENT TO THE TARGET TO BE APPLIED

IIDR 11.3.3.2-25 for Sybase
* Upgrade JDBC Driver version

IIDR 11.3.3.2-25 for Teradata
* Support of Teradata v15.10

IIDR 11.3.3.2-23 for all LUW engines can be found on Fix Central

All Engines:

APARs:
JR54961 EXCEPTION WHILE TRYING TO MODIFY DDL STATEMENTS THROUGH A DDL USER EXIT
JR54841 DUPLICATE MESSAGES SENT BY REPLICATION AGENT

IIDR 11.3.3.2-23 for Netezza
New Functionality:
* Improved performance of support assistant collection

APARs:
JR54762 SUPPORT ASSISTANT HANGS. THIS PREVENTS THE SUBSCRIPTION FROM EXECUTING AN ABORT/SHUTDOWN AFTER IT HITS AN UNCAUGHT EXCEPTION
JR54809 NULL POINTER EXCEPTION GENERATED WHEN AUTOCOMMIT USED ON SOURCE WITH CDC NETEZZA TARGET

IIDR 11.3.3.2-23 for DataStage

New Functionality:

* More robust start-up for Direct Connect auto-start subscriptions after replication was ended.

IIDR 11.3.3.2-23 for Oracle
APARs:
JR54810 NULLPOINTEREXCEPTION WHILE HANDLING INTERVAL ON THE INTERNAL HISTORY
JR54777 REGISTRATION PROGRAM, DMARCHIVELOGAVAILABLE FAILS DUE TO -1 BYTE ERROR.

IIDR 11.3.3.2-19 for all LUW engines can be found on Fix Central

IIDR 11.3.3.2-19 for all engines can be found on Fix Central.

* Single installer per operating system for all IIDR CDC Linux, Unix and Windows products. Please see the following wiki page for additional information on the single installer.

* Performance improvements in the CDC apply on Linux, Unix and Windows.

IIDR 11.3.3.2-19 for Netezza


* Now supports NPS 7.2.1, including the NZ JDBC driver included with NPS 7.2.1
* Improves performance when deleting rows on NULLable columns for NPS 7.2.1
* Fixed issue in target bulk apply that reduced batch sizes following immediate shutdown of subscriptions which leak memory, leading to poor performance
* Prevents StackOverflowError when NPS system reports warnings through JDBC driver
* Apply Engine no longer stops with out of file handle exception when running in IDAA environment
* Now supports specifying non-default Netezza session priority for bulk loads
* Corrected setting session priority after a database session is created
* Fixed issue where BLOB matched to data type UNKNOWN on Netezza targets

IIDR 11.3.3.2-19 for DataStage

* Now disallows older Management Console clients from connecting to DataStage agents
* Direct connect dsjob_wait_time_second value was mistakenly multiplied by 1000 in determining sleep time

IIDR 11.3.32-19 for Event Server

APARS
JR53811: CDC EventServer : Fixes an issue where a transaction with multiple operations has a CCID value larger than can be contained in a 31-bit integer, the first operation in transaction will have non-zero CCID value

IIDR 11.3.3.2-19 for Oracle

APARs
JR54714 LOB COLUMNS MAY BE UPDATED WITH VALUES FROM A DIFFERENT ROW

IIDR 11.3.3.2-19 for Sybase

* Now supports Sybase 16.
APARs
JR53370 CDC DATA LOSS / CONSISTENCY UPOEN CDC RESTART AFTER ABORT
JR52973 DMSHUTDOWN COMMAND WITH -A OPTION DOESN'T TERMINATE SUBSCRIPTIONS

IIDR 11.3.3.2-19 for DB2 LUW

IIDR for DB2LUW will not automatically map identical columns during table assignment if the column name is larger than 30 characters.
APARs
JR54344 IF SCHEDULED END IS ISSUED WHILE THE SUBSCRIPTION IS JOINING SHAREDSCRAPE THE SUBSCRIPTION MAY STALL OR NOT END

IIDR 11.3.3.2-19 for Teradata

* TPUMP apply is no longer available.


IIDR 11.3.3.2-5258 for Management Console and Access Server can be found on Fix Central.

* Support for the IIDR 11.3.3.2 LUW engines.

* Removed deprecated online.exe scripting language environment. See replacement CHCCLP scripting capability documentation.

IIDR 11.3.3.2-8 for Netezza has been released and is available on Fix Central

APAR:
JR54122 TARGET TABLE GETTING TRUNCATED WHEN USING LIVE AUDIT
 

New functionality (released in 11.3.3.2-5):
* Now supports configuring an instance on a PureData System for Analytics appliance with multiple schema support enabled.
* Now supports the VARBINARY datatype
* Performance improvements in bookmark processing

IIDR 11.3.3.2-8 for Informix has been released with new functionality and can be found in Fix Central

New functionality:
• IIDR for Informix supports replicating data using Multi-node Active Cluster for High-availability connections
• IIDR for Informix embeds an updated Informix JDBC driver, version 4.10.JC5.

Documentation Link:

http://www.ibm.com/support/knowledgecenter/SSTRGZ_11.3.3/com.ibm.cdcdoc.cdcforinformix.doc/concepts/configuringcdc.dita?lang=en

IIDR 11.3.3.1-4 has been released

IIDR 11.3.3.1-4 has been released with new functionality in addition to resolving some APARs. IIDR 11.3.3.1-4 can be found on Fix Central. New functionality: * No IIDR downtime support for Microsoft SQL Server non-structural online index rebuild operations

Index and table reorganizations done to improve query performance no longer impact replication. Replication will continue with no outage and with no user actions required.

* Log based change capture for Oracle is now supported on Microsoft Windows * No IIDR downtime support for Oracle Automatic Storage Management rebalancing activities

Previously in some situations rebalancing of ASM could could require replication be restarted

* An unplanned failure of Oracle to a DataGuard standby database no longer requires a resynchronization

Previously if an Oracle database being used as a source of changes failed over to an Oracle DataGuard standby, you would have been required to refresh the target data before restarting replication

* IIDR can now capture changes directly from ASM on Exadata

Previously replication required the ASM logs to be multiplexed to a non-ASM destination which typically could only be accomodated off the Exadata appliance

* IIDR can now target Cloudant * IIDR can now use webHDFS to deliver change data to HDFS

This allows IIDR to be installed remotely from the cluster and enables targeting HDFS deployments that are secured via Kerberos

APARs:

JR53019 POTENTIAL FOR DUPLICATE TRANSACTION REPLAY ON THE TARGET DUE TO INCORRECT BOOKMARKING ON IMMEDIATELY PREVIOUS SHUTDOWN.
JR53294 CDC TRIES TO READ AN UNCOMPLETED ORACLE LOG AND GETS ERROR IN LOG SHIPPING USING DATAGUARD SCENARIO.
JR53370 CDC DATA LOSS / CONSISTENCY UPOEN CDC RESTART AFTER ABORT
JR52825 CDC FOR DATASTAGE IN DIRECTCONNECT MODE NOT HONOURING THE DELAY PARAMETER FROM BATCH THRESHOLD SUBS PROPERTY
JR52973 DMSHUTDOWN COMMAND WITH -A OPTION DOESN'T TERMINATE SUBSCRIPTIONS
JR52797 ADDRESSING AN IDENTIFIED BUFFER OVERRUN CONDITION IN THE ORACLE SOLARIS JVM
JR53411 SETTING BLOB/CLOB TRUNCATION IN DATASTAGE PROPERTIES FOR A SUBSCRIPTION, REVERSES THE LIMITS
JR52923 TIMESTAMP IS NOT PROPERLY REPLICATING
JR53413 HAVING ROW SIZES GREATER THAN 341333 BYTES THROWS JAVA.NIO.BUFFEROVERFLOWEXCEPTION
JR52946 INSTANCE USING UPPER CASE ORACLE SID FOR STANDBY DATABASE CANNOT BE CREATED
JR53340 IIDR FOR ORACLE 12C FAILS TO START REPLICATION WHEN AN INSCOPE TABLE WAS ALTERED

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"ARM Category":[{"code":"a8m50000000L3DtAAK","label":"CDC->Engine Issues->Source Engine Issues"},{"code":"a8m50000000L3DjAAK","label":"CDC->Engine Issues->Target Engine Issues"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF051","label":"Linux on IBM Z Systems"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

Change Data Capture;Change Data Delivery; IBM Data Replication;IBM InfoSphere Data Replication;CDC;IDR;IIDR;CDD

Document Information

Modified date:
15 September 2021

UID

ibm11110471

Page Feedback