IBM Support

Release Notes for IDR 11.4 for Oracle

Fix Readme


Abstract

Release Notes for IBM Data Replication 11.4 Replication Engine for Oracle

Content

Release notes for other IDR 11.4 LUW Replication Engines can be found here: Release Notes for IIDR 11.4 Replication Engines for Linux, Unix and Windows

Binaries are available on Fix Central 

December 19, 2025

IDR 11.4.0.5-5789

Enhancements in IDR 11.4.0.5-5789 for CDC Replication Engine for Oracle

  • Updated JVM to 17.0.17.0, java version "17.0.17" 2025-10-21 IBM Semeru Runtime Certified Edition 17.0.17.0 (build 17.0.17+10). For details, see IBM Semeru Runtimes fixes for version 17 enhancement luw-base
  • Updated various open source libraries. Installer size increased.

Known Issues fixed in IDR 11.4.0.5-5789 for CDC Replication Engine for Oracle

  • DT456912 CDC Replication Engine for Oracle (Redo) can fail with "Invalid record size detected" error in a remote log reading configuration when an online log switch happened while CDC was processing the same online log

Bugs fixed in IDR 11.4.0.5-5789 for CDC Replication Engine for Oracle

  • External Secret Store fields are missing from the Windows configuration tool dmconfigurets

November 28, 2025

IDR 11.4.0.5-5788

Enhancements in IDR 11.4.0.5-5788 for CDC Replication Engine for Oracle

  • Dmshowversion command output now includes Java version

Known Issues fixed in IDR 11.4.0.5-5788 for CDC Replication Engine for Oracle

  • DT456860 CDC Replication Engine targets - refresh performance can be lower when using multiple image builder threads

November 28, 2025

IDR 11.4.0.5-5786

Known Issues fixed in IDR 11.4.0.5-5786 for CDC Replication Engine for Oracle

  • DT455098 CDC Replication Engine for Oracle - subscriptions end on error "Invalid Record Size Error" after reaching head-of-log

October 30, 2025

IDR 11.4.0.5-5785

Enhancements in IDR 11.4.0.5-5785 for CDC Replication Engine for Oracle

  • IDR supports Oracle 19.26+

Known Issues fixed in IDR 11.4.0.5-5785 for CDC Replication Engine for Oracle

  • DT448348 CDC Replication Engines do not set JVM parameter -Xms after saving configuration
  • DT451895 CDC Replication Engine for Oracle - subscriptions end on error "Invalid Record Size Error" when reading active online log
  • DT449979 CDC Replication Engine for Oracle - engine causes ORA-00910 errors in the Oracle alert log if Extended Data Type is not enabled

Bugs fixed in IDR 11.4.0.5-5785 for CDC Replication Engine for Oracle

  • com.datamirror.ts.assertion.NecessityException with encoding not supported error reported after upgrading CDC.
  • MsgReaddTableshandler.readdPublishedTable() can block metadata access when getting the latest column definitions
  • External table load while mirror call to dmmarkexternalunloadend fails with "Attempt to mark end of external unload without marking start of external unload for table"
  • Message to get the DB columns for a table holds metadata lock too long so it locks out other threads

September 30, 2025

IDR 11.4.0.5-5783

Enhancements in IDR 11.4.0.5-5783 for CDC Replication Engine for Oracle

  • CDC is now supported in OpenShift Virtualization clusters, with configuration guidance available in the Knowledge Center.
  • Updated JVM to 17.0.16.0, java version "17.0.16" 2025-07-15 IBM Semeru Runtime Certified Edition 17.0.16.0 (build 17.0.16+8). For details, see IBM Semeru Runtimes fixes for version 17
  • Implement a global %REPLACE functionality that would replace all matching characters in all columns of all tables.
  • IDR now supports External Parallel Table Load (Refresh) while mirroring.

Known Issues fixed in IDR 11.4.0.5-5783 for CDC Replication Engine for Oracle

  • DT450444 Differential Refresh deletes all remaining rows in the target table if the subscription is stopped immediate or abort

September 1, 2025

IDR 11.4.0.5-5776

Enhancements in IDR 11.4.0.5-5776 for CDC Replication Engine for Oracle

  • System property target_allow_parallel_jdbc_refresh has been added to enable JDBC refresh of a table to be performed by multiple apply threads.

APARs fixed in IDR 11.4.0.5-5776 for CDC Replication Engine for Oracle

  • DT447888 INVALID TABLE NAME EXCEPTION WHEN RUNNING DMREMOVECLOSEDTXN UTILITY IF PERSISTED PRIVATE PARSER TXN QUEUES EXIST AND THE CORRESPONDING SUBSCRIPTION NAME IS NOT EXACTLY 12 CHARACTERS IN LENGTH.

Known Issues fixed in IDR 11.4.0.5-5776 for CDC Replication Engine for Oracle

  • DT447888 INVALID TABLE NAME EXCEPTION WHEN RUNNING DMREMOVECLOSEDTXN UTILITY IF PERSISTED PRIVATE PARSER TXN QUEUES EXIST AND THE CORRESPONDING SUBSCRIPTION NAME IS NOT EXACTLY 12 CHARACTERS IN LENGTH.

August 1, 2025

IDR 11.4.0.5-5770

Enhancements in IDR 11.4.0.5-5770 for CDC Replication Engine for Oracle

  • IDR now supports cipher suites TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384 and TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256 with TLS 1.2.
  • IDR now supports Ubuntu 22.04 LTS and 24.04 LTS
  • The system properties queue_blocking_call_before_flushing_timeout and target_optimizer_wait_timeout_millis can now be changed without requiring the subscription to be stopped before the changes take effect
  • The system properties queue_blocking_call_before_flushing_timeout and target_optimizer_wait_timeout_millis can now be set on a per-subscription basis

Bugs fixed in IDR 11.4.0.5-5770 for CDC Replication Engine for Oracle

  • Fixed the issue that caused %TOCHAR expression to fail with "newValue is out of valid range" error while using decimal parameters after upgrade

June 27, 2025

IDR 11.4.0.5-5768

Enhancements in IDR 11.4.0.5-5768 for CDC Replication Engine for Oracle

  • Batching is now allowed when using a NetEffectConvertUpdates fast apply algorithm for Adaptive Apply mappings or during the Refresh While Active (RWA) period. This substantially improves performance in these situations.
  • Insert batching via a single multi-row insert statement is now supported when JDBC insert batching does not deliver signficant performance gains.
  • Adaptive Apply (AA) is now only performed during refresh if table truncate is disabled or the user has explicitly specified they want AA during refresh by setting a system property. This substantially improves refresh performance for AA mappings by allowing Fastload refresh and JDBC batching during JDBC refresh

Known Issues fixed in IDR 11.4.0.5-5768 for CDC Replication Engine for Oracle

  • DT442954 CDC Replication Engines - subscriptions intermittently fail to start with "startup timeout has occurred. Replication will end" event

June 4, 2025

IDR 11.4.0.5-5765

Enhancements in IDR 11.4.0.5-5765 for CDC Replication Engine for Oracle

Known Issues fixed in IDR 11.4.0.5-5765 for CDC Replication Engine for Oracle

  • DT438079 CDC Replication Engine for Oracle (Redo) configured with archive only mode does not abort subscription when required archived log is missing
  • DT438085 CDC Replication Engines - Event notification with SMTP fails with javax.mail.AuthenticationFailedException after secret store changes. The fix is available in 11.4.0.5-5752 and newer.

Bugs fixed in IDR 11.4.0.5-5765 for CDC Replication Engine for Oracle

  • Non inline LOBs in a JDBC batch are not closed

May 1, 2025

IDR 11.4.0.5-5761

Known Issues fixed in IDR 11.4.0.5-5761 for CDC Replication Engine for Oracle

  • DT435382 CDC Replication Engine for Oracle databases (Redo) may incorrectly parse LOB-related log entries when related table operations are rolled back then followed by DML on a different table.

April 4, 2025

IDR 11.4.0.5-5757

Enhancements in IDR 11.4.0.5-5757 for CDC Replication Engine for Oracle

Known Issues fixed in IDR 11.4.0.5-5757 for CDC Replication Engine for Oracle

  • DT424560 CDC Replication Engine for Oracle - when supplemental logging is not enabled, replication performance drops. Available in 11.4.0.5-5762 and newer.
 
 

February 28, 2025

IDR 11.4.0.5-5752

Enhancements in IDR 11.4.0.5-5752 for CDC Replication Engine for Oracle

  • Updated JVM to 17.0.13.0, java version "17.0.13" 2024-10-15 IBM Semeru Runtime Certified Edition 17.0.13.0 (build 17.0.13+11). How to take a backup, recompile Java user exits, KCOPs and external secret store classes are described in CDC Replication Engines migrate from Java 8 to Java 17, along with troubleshooting tips.
  • Effective July 2025, IDR CDC will no longer provide support for following operating system versions: RedHat Enterprise Linux (RHEL) 7; CentOS 7.x. This extends support from January 2025 through July 2025

Known Issues fixed in IDR 11.4.0.5-5752 for CDC Replication Engine for Oracle

  • DT425067 CDC Replication Engine for Oracle - Log Parser throws NullPointerException for a subscription that was left inactive for longer time

January 30, 2025

IDR 11.4.0.5-5744

Known Issues fixed in IDR 11.4.0.5-5744 for CDC Replication Engine for Oracle

  • DT422555 Performance issue in the Oracle Redo Parser when update operation non-updated column values are not available due to supplemental logging not being enabled

December 20, 2024

IDR 11.4.0.5-5742

Enhancements in IDR 11.4.0.5-5742 for CDC Replication Engine for Oracle

  • Added support for Oracle 23ai. Target supports BOOLEAN datatype. Source does not support new datatypes introduced in Oracle 23ai.
  • Updated JVM to 8.0.8.35, java version "1.8.0_431" Java(TM) SE Runtime Environment (build 8.0.8.35 - pap6480sr8fp35-20241105_01(SR8 FP35)). For details, see Java SDK fixes, version 8.0. Recompile Java user exits, KCOPs and external secret store classes.

Known Issues fixed in IDR 11.4.0.5-5742 for CDC Replication Engine for Oracle

  • DT419093 CDC Replication Engines for Oracle (redo, trigger, XStream) - creating a CDC instance raises SQL Error ORA-01031: insufficient privileges after connecting to a 'Serverless' Autonomous Database instance.
  • DT419421 CDC Replication Engines - command line utilities might not properly negotiate TLS settings with the local engine

December 9, 2024

IDR 11.4.0.5-5740

Enhancements in IDR 11.4.0.5-5740 for CDC Replication Engine for Oracle

  • Provide ability to trim trailing whitespace characters from source character-type columns when being applied to varchar columns

Known Issues fixed in IDR 11.4.0.5-5740 for CDC Replication Engine for Oracle

  • DT398056 CDC target Replication Engines - differential refresh log table name was generated incorrectly
  • DT416679 CDC Replication Engines - Subscription does not stop if data channel and/or control channel connection is implicitly closed due to error
  • DT418775 CDC Replication Engines - Following upgrade, engines using an External Secret Store User Exit may fail to start, reporting invalid user/password to customer database. Affects upgrades to 11.4.0.5-5735 or older.
 

October 31, 2024

IDR 11.4.0.5-5735

Known Issues fixed in IDR 11.4.0.5-5735 for CDC Replication Engine for Oracle

  • DT398190 CDC Replication Engine for Oracle (Redo) - rules-based subscription mirroring can fail with "ORA-00922" error on target when the source table and its primary key were created in separate DDL statement instead of one DDL statement

October 2, 2024

IDR 11.4.0.5-5733

Enhancements in IDR 11.4.0.5-5733 for CDC Replication Engine for Oracle

  • Updated JVM to 8.0.8.30, java version "1.8.0_421" Java(TM) SE Runtime Environment (build 8.0.8.30 - pwa6480sr8fp30-20240801_01(SR8 FP30))
  • %REPLACE derived expression can now replace codepoints above 127

Known Issues fixed in IDR 11.4.0.5-5733 for CDC Replication Engine for Oracle

  • DT397104 CDC Replication Engines for Oracle (redolog, XStream and Trigger) - target engine deletes are slow when a table index includes Column Collation
  • DT395890 CDC Replication Engines - an instance being used as a source datastore can stop due to NullPointerException in singlescrape
  • DT396565 CDC Replication Engines - Target engine Fast Apply does not retry if it encounters a SQL exception such as a commit failing

Bugs fixed in IDR 11.4.0.5-5733 for CDC Replication Engine for Oracle

  • dmshowversion, dmconfigurets unable to run if you select "IBM Data Replication IMS for z/OS Remote Source" offering during installation

September 10, 2024

IDR 11.4.0.5-5731

Enhancements in IDR 11.4.0.5-5731 for CDC Replication Engine for Oracle

  • Users can now specify subscriptions that are not allowed to use the shared scrape staging store by setting system property mirror_subs_allowed_to_use_staging_store to false at the subscription level

Known Issues fixed in IDR 11.4.0.5-5731 for CDC Replication Engine for Oracle

  • DT392725 CDC Replication Engine for Oracle databases - Subscription can abort with "The table definition may have changed" error due to unexpected entry type when the subscription has an in-scope table that has a VARCHAR2(4000) type column being mirrored
  • DT394553 CDC Replication Engines - subscription ends on error NullPointerException when a commit fails on the target engine
  • DT394429 CDC Replication Engines for Oracle fail to start following upgrade of Oracle 19c to RU24
  • DT393813 CDC Replication Engines - Differential Refresh includes CDR columns in update and delete where clauses leading to rows not being found

September 10, 2024

IDR 11.4.0.5-5730

Enhancements in IDR 11.4.0.5-5730 for CDC Replication Engine for Oracle

  • CDC Replication Engines now issue a warning if source and target columns have incompatible datatypes during table assignment for non-explicitly mapped columns
  • System property mirror_timezone_support_enabled added to force CDC Replication Engines to use the source timezone when converting JCF and commit timestamps

Known Issues fixed in IDR 11.4.0.5-5730 for CDC Replication Engine for Oracle

  • DT391851 CDC Replication Engine for Oracle - Oracle Session History Pointbase database lock timeout during session history cleanup

ATTENTION:
CDC Replication Engines for Oracle fail to start following upgrade of Oracle 19c to RU24.
Before applying Oracle 19c Refresh Update 24 (RU24), review Known Issue DT394429

June 27, 2024

IDR 11.4.0.5-5726

Enhancements in IDR 11.4.0.5-5726 for CDC Replication Engine for Oracle

  • Effective January 2025, IDR CDC will no longer provide support for following operating system versions: RedHat Enterprise Linux (RHEL) 7; CentOS 7.x

Known Issues fixed in IDR 11.4.0.5-5726 for CDC Replication Engine for Oracle

  • DT390365: CDC Replication Engine for Oracle cannot create new Instance to database using ASM Storage.
  • DT390378 : CDC Replication Engine for Oracle - dmsupportinfo collection may raise an exception attempting to gather ASM related info when not used in IIDR Configuration

June 4, 2024

IDR 11.4.0.5-5725

Enhancements in IDR 11.4.0.5-5725 for CDC Replication Engine for Oracle

  • IIDR now provides the option of retrying the fast apply failed Unit of Work
  • Updated JVM to 8.0.8.25, java version "1.8.0_411" Java(TM) SE Runtime Environment (build 8.0.8.25 - pwa6480sr8fp25-20240328_01(SR8 FP25))

Known Issues fixed in IDR 11.4.0.5-5725 for CDC Replication Engine for Oracle

  • DT382379 CDC Replication Engines - dmsupportinfo command does not collect complete details expected.

May 23, 2024

IDR 11.4.0.5-5722

Known Issues fixed in IDR 11.4.0.5-5722 for CDC Replication Engine for Oracle

  • DT258648 CDC Replication Engines - Replication ends on error "ClassNotFoundException" for Timestamp12Format class when executing a user exit that uses Timestamp12 class

May 1, 2024

IDR 11.4.0.5-5721

Enhancements in IDR 11.4.0.5-5721 for CDC Replication Engine for Oracle

  • CDC now supports custom character sets that map multiple byte sequences to the same Unicode character.

Known Issues fixed in IDR 11.4.0.5-5721 for CDC Replication Engine for Oracle

  • DT259380 CDC Replication Engine for Oracle Redo - PDB level ALL COLUMN Supplemental Logging not accepted as sufficient with a Read-only Instance
  • DT379082 CDC Replication Engines for Db2 for z/OS remote source , Db2 Luw, Oracle Redo - Subscription stops abort with NecessityException "opcode is not mapped to a SourceOperation type"
 

March 28, 2024

IDR 11.4.0.5-5715

Enhancements in IDR 11.4.0.5-5715 for CDC Replication Engine for Oracle

  • Document userexit interfaces such as UserExitIF, DataRecordIF and ReplicationEventIF in docs folder
 

March 1, 2024

IDR 11.4.0.5-5706

Enhancements in IDR 11.4.0.5-5706 for CDC Replication Engine for Oracle

  • Updated JVM to 8.0.8.20, java version "1.8.0_401" (build 8.0.8.20 - pwa6480sr8fp20-20240112_01(SR8 FP20))
  • Increased the requested maximum number of pending connections on the TCP accept queue

Known Issues fixed in IDR 11.4.0.5-5706 for CDC Replication Engine for Oracle

  • DT260407 CDC Replication Engine for Oracle - instance configuration tool dmconfigurets gives error "ORA-12656: Cryptographic checksum mismatch" when trying to connect to Oracle db using Kerberos authentication

Bugs fixed in IDR 11.4.0.5-5706 for CDC Replication Engine for Oracle

  • NecessityException could occur when running a table level user exit with any of the parallel hash fast apply algorithms

January 25, 2024

IDR 11.4.0.5-5703

Enhancements in IDR 11.4.0.5-5703 for CDC Replication Engine for Oracle

  • Effective February 2024, IDR CDC will no longer provide support for Oracle 11g and 12.1
  • Effective February 2024, IDR CDC will no longer provide support for following operating system versions: SuSE 11.0; Ubuntu 16.04; Oracle Linux 6.x; CentOS 6.x; AIX 7.1; Microsoft Windows 7, 8, 8.1, Server 2008, Server 2008R2

Bugs fixed in IDR 11.4.0.5-5703 for CDC Replication Engine for Oracle

  • When a key column update is converted to a delete/insert, we unnecessarily use Adaptive Apply as the RWA conflict resolution method for the delete and insert

December 22, 2023

IDR 11.4.0.5-5702

Enhancements in IDR 11.4.0.5-5702 for CDC Replication Engine for Oracle

  • Added ParallelizeByHash, ParallelizeByHashNetEffect, and ParallelizeByHashNetEffectConvertUpdates fast apply algorithms

Bugs fixed in IDR 11.4.0.5-5702 for CDC Replication Engine for Oracle

  • Specifying the number of image builder threads via the NullMirrorOptimizer fast apply user exit causes subscription to stop

December 5, 2023

IDR 11.4.0.5-5700

Enhancements in IDR 11.4.0.5-5700 for CDC Replication Engine for Oracle

  • If system property mirror_refresh_while_active_resolution_method is set to IGNORE_CONFLICTS, CDC no longer uses full Adaptive Apply to resolve conflicts when applying operations that occurred during the refresh-while-active period for a table. Instead, conflicts are resolved in a simpler, more efficient way that allows JDBC batching.
  • Updated various open source libraries

Bugs fixed in IDR 11.4.0.5-5700 for CDC Replication Engine for Oracle

  • NecessityException can occur when target is using fast apply and the Unit Of Work has to be reapplied due to an exception and adaptive apply was used when applying an operation in the UOW

October 30, 2023

IDR 11.4.0.5-5699

Bugs fixed in IDR 11.4.0.5-5699 for CDC Replication Engine for Oracle

  • Fix incorrect product version shown in Windows program manager
 

September 28, 2023

IDR 11.4.0.5-5696

Enhancements in IDR 11.4.0.5-5696 for Oracle

  • Updated JVM to 8.0.8.11, java version "1.8.0_381"

Bug fixes in IDR 11.4.0.5-5696 for Oracle

  • Staging store can be starved for memory if transaction queues use it all, resulting in subscriptions cycling constantly between private and shared scrape even though the staging store quota has not been reached yet

August 30, 2023

IDR 11.4.0.4-5694

Enhancements in IDR 11.4.0.4-5694 for Oracle

  • Updated JVM to 8.0.8.6, java version "1.8.0_371" (build 8.0.8.6 - pxz6480sr8fp6ifix-20230817_01(SR8 FP6+IJ47696))

Bug fixes in IDR 11.4.0.4-5694 for Oracle

  • Oracle fails with NeccessityException "Unexpected history action transition ALTER_COLUMN to ADD_COLUMN"
 

July 31, 2023

IDR 11.4.0.4-5686

Enhancements in IDR 11.4.0.4-5686 for Oracle

  • Added utility dmremoveclosedtxn to remove a committed/aborted transaction from the transaction queues
  • Added utility dmsetrestartposition to set the restart position of a subscription bookmark
  • Updated JVM to 8.0.8.6, java version "1.8.0_371"

APARs in IDR 11.4.0.4-5686 for Oracle

  • JR65293 NUMERIC OVERFLOW ERROR WHEN GETTING METADATA FOR TABLE IN REDO/XSTREAM ENGINE

Bug fixes in IDR 11.4.0.4-5686 for Oracle

  • Parallel refresh can hang if normal stop request or uncaught exception occurs at the beginning of the refresh

July 14, 2023

IDR 11.4.0.4-5684

Enhancements in IDR 11.4.0.4-5684 for Oracle

  • Added DDL Resiliency handling for Oracle Redo

APARs in IDR 11.4.0.4-5684 for Oracle

  • JR65291 DUPLICATE KEY ERROR AFTER REFRESH USING FAST LOAD WITH CURSOR STABILITY ISOLATION LEVEL FROM DB2 Z/OS SOURCE TO ORACLE TARGET

May 30, 2023

IDR 11.4.0.4-5676

Enhancements in IDR 11.4.0.4-5676 for Oracle

  • Added ParallelizeByTableNetEffect and ParallelizeByTableNetEffectConvertUpdates fast apply algorithms

April 27, 2023

IDR 11.4.0.4-5674

Enhancements in IDR 11.4.0.4-5674 for Oracle

  • Updated JVMs to 8.0.8.0

APARs in IDR 11.4.0.4-5674 for Oracle

  • JR65266 ARRAY INDEX OUT OF BOUNDS EXCEPTION IF MAPPING HAS MULTIPLE DERIVED COLUMNS AND A SELECTED DERIVED COLUMN FOLLOWS AN OMITTED DERIVED COLUMN

March 31, 2023

IDR 11.4.0.4-5672

Enhancements in IDR 11.4.0.4-5672 for Oracle

  • Introduced new undocumented parameter oracle_include_partition_id_list_file_name to replicate only listed partitions.
  • New derived expression %ORDERTAB(), to track per table record sequence number, is now supported on target agent.
  • Updated JVMs to 8.0.7.20

APARs in IDR 11.4.0.4-5672 for Oracle

  • JR65236 CDC ORACLE CAN RETURN FOLLOWING ERROR WHEN USING KERBEROS AUTHENTICATION: [CDC][ORACLE JDBC DRIVER]NULL

Bug fixes in IDR 11.4.0.4-5672 for Oracle

  • In some low volume workloads latency can be 1-5 seconds more than it should be

March 3, 2023

IDR 11.4.0.4-5670

Enhancements in IDR 11.4.0.4-5670 for Oracle

  • Prevent JDBC refresh from failing with duplicate key exceptions during standard apply

APARs in IDR 11.4.0.4-5670 for Oracle

  • JR65217 CDC FAILS WITH NPE DURING ORACLE REMOTE LOG READING
  • JR65219 IDR ORACLE REDO COULD LOSE OPERATION IF AN ORACLE REDO LOG WAS DEEMED CORRUPT AND HAS TO RETRY WITH A DIFFERENT ACCESS METHOD OR DIFFERENT MEMBER, INCLUDING MISSING COMMIT/ROLLBACK OF A TRANSACTION WHICH CAN LEAD TO RESTART POSITION OF BOOKMARK NOT MOVING FORWARD
  • JR65196 IDR ORACLE REDO WOULD FAIL TO READ ASM MANAGED LOG IF THE ARCHIVE/REDO LOG FILE EXCEEDS 20000MB AND THE ASM COMPATIBLE VERSIONS HAVE 0 IN THE MINOR VERSION.
  • JR65110 REFRESH NUMBER OF ROWS SUCCESSFULLY APPLIED CAN BE NEGATIVE
  • JR65235 ROW FILTER &ENTTYP='UB' NEVER MATCHES, AND &ENTTYP='UP' MATCHES BOTH UB AND UP ROWS

February 3, 2023

IDR 11.4.0.4-5666

Enhancements in IDR 11.4.0.4-5666 for Oracle

  • IDR now supports TLS 1.3 in addition to TLS 1.2 for communication between Management Console, Access Server, source datastores and target datastores. For improved security, only the most secure protocols are supported for TLS 1.3 (TLS_AES_256_GCM_SHA384, TLS_AES_128_GCM_SHA256) and TLS 1.2 (TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, TLS_DHE_RSA_WITH_AES_256_GCM_SHA384, TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256, TLS_DHE_RSA_WITH_AES_128_GCM_SHA256).

APARs in IDR 11.4.0.4-5666 for Oracle

  • JR65211 CDC FOR ORACLE (REDO) CAN HIT "OUT OF ORDER ENTRY" ERROR (FOUND IN THE INSTANCE TRACE FILE) WHEN LOG READER WAS RESTARTED DUE TO DDL

Bug fixes in IDR 11.4.0.4-5666 for Oracle

  • TCP/IP connections are closed prematurely when encrypted with TLS.
  • "PKIX path building failed" error while retrieving schemas from the database over TLS, even though the database's root CA certificate was configured in the encryption profile's trust store.

December 22, 2022

IDR 11.4.0.4-5661

Enhancements in IDR 11.4.0.4-5661 for Oracle

  • 6-digit sequence value is added to &TIMSTAMP timestamps that have only seconds precision to simulate microseconds if system property timstamp_jcf_add_microsecond_counter is set to true
  • JDBC batching is now allowed if target table before-operation user exits exist

APARs in IDR 11.4.0.4-5661 for Oracle

  • JR64532 FOR TRUNCATE OPERATIONS, &TIMSTAMP VALUE NOW CORRECTLY REPLICATES RECORD MODIFICATION TIME, INSTEAD OF CURRENT TIME.

November 25, 2022

IDR 11.4.0.4-5660

APARs in IDR 11.4.0.4-5660 for Oracle

  • JR64799 IGNORE PARTIAL LOGICAL LOG ENTRY 0501 SPLIT OPERATION
  • JR65189 CDC ORACLE REDO LOG SCRAPER CALCULATES THE RECORD HEADER SIZE INCORRECTLY AND DECLARES INVALID RECORD SIZE ERROR.
  • JR65196 IDR ORACLE REDO WOULD FAIL TO READ ASM MANAGED LOG IF THE ARCHIVE/REDO LOG FILE EXCEEDS 20000MB AND THE ASM COMPATIBLE VERSIONS HAVE 0 IN THE MINOR VERSION.

October 31, 2022

IDR 11.4.0.4-5659

Enhancements in IDR 11.4.0.4-5659 for Oracle

  • Added property target_apply_assume_db_enforces_unique_key_violations that indicates whether CDC should assume the target database enforces unique key violations
  • Do not send DML operation if column participating in row filtering condition is updated

APARs in IDR 11.4.0.4-5659 for Oracle

  • JR64443 MULTIPLE ORACLE DB INCARNATION WITH SAME RESETLOG_CHANGE# CAN CAUSE CDC TO BE UNABLE TO IDENTIFY ARCHIVED LOG TO BE SCRAPED

September 28, 2022

IDR 11.4.0.4-5656

Enhancements in IDR 11.4.0.4-5656 for Oracle

  • Performance optimization added for applying all deletes in a batch as a single delete statement. Dramatically improves performance of applying deletes against column organized tables. Enabled by setting system property target_apply_delete_batch_via_single_statement = true

APARs in IDR 11.4.0.4-5656 for Oracle

  • JR65137 CDC ORACLE REDO DOES NOT ALWAYS TRY TO RE-READ ASM MANAGED REDO LOG USING ORACLE PACKAGE IF NATIVE FILE ACCESS HITS LOG CORRUPTION ERROR.
  • JR65156 NPE EXCEPTION WHILE CLICKING ON USE READ-ONLY CONNECTION TO DATABASE CHECKBOX IN DMCONFIGURETS WINDOWS UI
  • JR65157 CDC ORACLE REDO LOG SCRAPER CAN INCORRECTLY DECLARE REDO LOG AS INVALID
  • JR65145 CDC COMMAND DMFLAGFORREFRESH SHOULD NOT ALLOW TO USE DIFFERENTIAL REFRESH (-DR) OPTION IF TARGET ENGINE DOESN'T SUPPORT IT

August 31, 2022

IDR 11.4.0.4-5652

Enhancements in IDR 11.4.0.4-5652 for Oracle

  • dmclearstagingstore no longer implicitly clears the shared scrape parser transaction queues as this is not necessary in most cases

APARs in IDR 11.4.0.4-5652 for Oracle

  • JR65123 TRUNCATION WARNING ISSUED EVEN THOUGH THERE IS NO NON-SPACE DATA TO BE TRUNCATED

July 29, 2022

IDR 11.4.0.4-5644

APARs in IDR 11.4.0.4-5644 for Oracle

  • JR65076 THE DMLS ON NEW PARTITION ARE NOT REPLICATED AFTER READD TABLE IF THE SUB IS STARTED WHEN AT LEAST ONE SUB IS MIRRORING

June 27, 2022

IDR 11.4.0.4-5643

Enhancements in IDR 11.4.0.4-5643 for Oracle

  • Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
  • Support storing replication engine database credentials in an external secret store
  • Updated JVMs to 8.0.7.10

APARs in IDR 11.4.0.4-5643 for Oracle

  • JR64981 IDR ORACLE JDBC DRIVER CAN FAIL WITH '[CDC][ORACLE JDBC DRIVER]OBJECT HAS BEEN CLOSED' WHEN IMPORTING SUBSCRIPTIONS.
  • JR65028 IIDR ORACLE REDO ON WINDOWS FAILS TO READ LOG FILES OVER 2GB

May 5, 2022

IDR 11.4.0.4-5629

APARs in IDR 11.4.0.4-5629 for Oracle

  • JR64794 LOG PARSER THROWS ARRAYINDEXOUTOFBOUNDSEXCEPTION
  • JR64799 IGNORE PARTIAL LOGICAL LOG ENTRY 0501 SPLIT OPERATION
  • JR64572 NO WARNING EVENT WHEN CHARACTER DATA IS TRUNCATED

March 30, 2022

IDR 11.4.0.4-5627

Enhancements in IDR 11.4.0.4-5627 for Oracle

  • Parallel Apply is now allowed with Adaptive Apply

APARs in IDR 11.4.0.4-5627 for Oracle

  • JR64736 WARNING 9700 CAN OCCUR AND DUPLICATE OPERATIONS APPLIED IF A SUBSCRIPTION IS USING SHARED SCRAPE AND STAGING STORE IS CLEARED

March 3, 2022

IDR 11.4.0.4-5625

Enhancements in IDR 11.4.0.4-5625 for Oracle

  • InstallAnywhere VM pack for CDC engine installer updated to Java 8.0.7.0
  • IDR added a new command line utility "dmimportuserconfiguration" to help automate creation of multiple product instances with user configured values

APARs in IDR 11.4.0.4-5625 for Oracle

  • JR64532 FOR TRUNCATE OPERATIONS, &TIMSTAMP VALUE NOW CORRECTLY REPLICATES RECORD MODIFICATION TIME, INSTEAD OF CURRENT TIME.
  • JR64650 POOR LOG PARSER PERFORMANCE WHEN OUT OF SCOPE DDL LOG RECORDS ARE PARSED
  • JR64618 DMTS64 PROCESS IS TAKING A LONGER TIME TO START

Bug fixes in IDR 11.4.0.4-5625 for Oracle

  • Fixed possible "duplicate key" or "row does not exist" error when replication key is being updated with ParallelizeSingleTableByHash fast apply algorithm

January 28, 2022

IDR 11.4.0.4-5622

Enhancements in IDR 11.4.0.4-5622 for Oracle

  • Java Runtime Environment updated from IBM Java 8.0.6.30 to 8.0.7.0. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/ . This resolves IJ35231 - Missing byte when retrieving LOB data from database.

APARs in IDR 11.4.0.4-5622 for Oracle

  • JR64487 CDC TREATS BEFORE IMAGE AS NULL FOR OUT OF PLACE UPDATE FOR COMPRESSED TABLE IF IT'S PRECEDED BY INSERT

January 4, 2022

IDR 11.4.0.4-5618

APARs in IDR 11.4.0.4-5618 for Oracle

  • JR64485 ADDRESSED ILLEGALARGUMENTEXCEPTION EMPTY KEY ERROR ISSUED DURING UPGRADE FOR SUBSCRIPTION ALERT HANDLERS CONFIGURED WITHOUT A SENDER EMAIL AND PASSWORD
 

December 17, 2021

IDR 11.4.0.4-5616

Enhancements in IDR 11.4.0.4-5616 for Oracle

  • Added slf4j-api-2.0.0-alpha5.jar, slf4j-jdk14-2.0.0-alpha5.jar
  • No longer bundle log4j-1.2.17.jar, slf4j-api-1.7.26.jar, slf4j-log4j12-1.7.26.jar dependencies

November 30, 2021

IDR 11.4.0.4-5611

APARs in IDR 11.4.0.4-5611 for Oracle

  • JR64335 OUTOFMEMORY OCCURS WHEN TLS ENCRYPTION IS ENABLED AND MANY AGENT CONNECTIONS ARE MADE TO THE INSTANCE

October 29, 2021

IDR 11.4.0.4-5609

Enhancements in IDR 11.4.0.4-5609 for Oracle

  • Added ability to handle Oracle DDL changes related to table partitions and avoid restarting IDR log reader if the table partitions already exist in metadata

APARs in IDR 11.4.0.4-5609 for Oracle

  • JR64221 CDC ABORT WHEN INCOMPLETE MULTI-BLOCK ENTRYS IS DETECTED

September 27, 2021

IDR 11.4.0.4-5607

APARs in IDR 11.4.0.4-5607 for Oracle

  • JR64119 IDR IS UNABLE TO ADD PARTITIONED TABLE IN ADW ENVIRONMENT
  • JR64110 IDR FAILS WITH NUMERIC OVERFLOW EXCEPTION WHEN TRYING TO EXTRACT INDEX DETAILS ON ORACLE 19C

Bug fixes in IDR 11.4.0.4-5607 for Oracle

  • Addressed an issue causing bootstrap- .jar, user-exit- .jar and kafka-engine-kcop- .jar to keep accumulating in lib folder after product upgrades

September 3, 2021

IDR 11.4.0.4-5603

APARs in IDR 11.4.0.4-5603 for Oracle

  • JR63951 IDR ORACLE CAN FAIL WITH JAVA.LANG.NULLPOINTEREXCEPTION WHEN CREATING READ-ONLY INSTANCE WITH KERBEROS AUTHENTICATION
  • JR64077 CDC FOR ORACLE (REDO) EVENT/TRACE LOG CAN BE FLOODED WITH MESSAGE "INTERNAL ERROR HAS OCCURRED..." AFTER DB UPGRADE TO 19C
  • JR64071 IDR CDC FAILS WITH STATEMENT CLOSED ERROR WHILE RUNNING ADDITIONAL SQL STATEMENTS DURING REFRESH.

Bug fixes in IDR 11.4.0.4-5603 for Oracle

  • Addressed an issue causing an OOM error if there are large number of trace files

July 29, 2021

IDR 11.4.0.4-5602

APARs in IDR 11.4.0.4-5602 for Oracle

  • JR63826 UNEXPECTED HISTORY ACTION TRANSITION DROP_PARTITION TO TRUNCATE_PARTITION
  • JR63795 CDC DOES NOT UPDATE SYSTEM TABLE STRUCTURE IN METADATA DURING ORACLE DATABASE UPGRADE

July 6, 2021

IDR 11.4.0.4-5599

Enhancements in IDR 11.4.0.4-5599 for Oracle

  • Add Kerberos authentication support for CDC for Oracle replication engines
  • Set length in bytes and described length correctly for an Oracle extended type column
  • Updated the Java Virtual Machine to IBM 8.0.6.30

APARs in IDR 11.4.0.4-5599 for Oracle

  • JR63805 UTILITY TRACE FILES ARE ALWAYS GENERATED EVEN IF GLOBAL_TRACE_UTILITY_CREATE_ON_DEMAND = TRUE IF GLOBAL TRACING WAS EVER ENABLED
  • JR63847 NECCESSITYEXCEPTION "CHANGE LOG BLOCK WE ARE TRYING TO READ IS EMPTY!" IF TIMING CIRCUMSTANCES ARE UNFORTUNATE
  • JR63844 NPE OR ASSUMPTION EXCEPTION IF SUBSCRIPTION IS USING SHARED SCRAPE AND STAGING STORE IS CLEARED OR DISK QUOTA EXCEEDED
  • JR63848 MEMORY LEAK IF SHARED SCRAPE STAGING STORE IS CLEARED WHEN MEMORY WAS TIGHT

Bug fixes in IDR 11.4.0.4-5599 for Oracle

  • Addressed an issue causing some persistent subscriptions to restart unexpectedly after the user stopped multiple subscriptions at the same time

May 26, 2021

IDR 11.4.0.3-5596

APARs in IDR 11.4.0.3-5596 for Oracle

  • JR63609 CDC FOR ORACLE (REDO) CONNECTION LEAK CAN OCCUR DURING METADATA MIGRATION

Bug fixes in IDR 11.4.0.3-5596 for Oracle

  • Fixed NecessityException in ChangeLogBlock on instance start up

April 28, 2021

IDR 11.4.0.3-5594

Enhancements in IDR 11.4.0.3-5594 for Oracle

  • IDR for Oracle now automatically refresh Oracle database system table information on startup

APARs in IDR 11.4.0.3-5594 for Oracle

  • JR63100 CDC IS DETECTING EXTRA ENTRY FOR QUICK MULTI DELETE
  • JR63523 UNEXPECTED HISTORY ACTION TRANSITION TRUNCATE_PARTITION TO ADD_PARTITION
  • JR63511 AUDIT WRONGLY DETECTS THAT REPLICATION ENGINE HAS MULTIPLE OFFERINGS INSTALLED
  • JR63191 DMTS64 CPU USAGE GOES TO NEAR 100% WHEN LAST SUB USING SHARED SCRAPE STOPS AND BEFORE ITS LOG PARSER AND READER STOP

March 31, 2021

IDR 11.4.0.3-5593

APARs in IDR 11.4.0.3-5593 for Oracle

  • JR63364 AFTER DDL ON INTERVAL PARTITIONED TABLE CDC STOPS REPLICATING DATA
  • JR63378 WHEN ALTER TABLE SPLIT PARTITION OPERATION IS ISSUED, LOG READER MAY FAIL AFTER "UNEXPECTED HISTORY ACTION TRANSITION ADD_PARTITION TO TRUNCATE_PARTITION" ERROR

Bug fixes in IDR 11.4.0.3-5593 for Oracle

  • IDR now processes all the logs, before declaring a sequence gap.

February 26, 2021

IDR 11.4.0.3-5590

APARs in IDR 11.4.0.3-5590 for Oracle

  • JR63301 IDR ORACLE FASTLOAD REFRESH CAN CAUSE A CORE DUMP IF THE CDC INSTANCE IS ALSO BEING USED AS A SOURCE FOR MIRRORING

Bug fixes in IDR 11.4.0.3-5590 for Oracle

  • JR63346 IDR now supports Fastload Refresh for Live Audit mapping

January 31, 2021

IDR 11.4.0.3-5587

APARs in IDR 11.4.0.3-5587 for Oracle

  • JR63222 SUBSCRIPTION FAILS WITH AN ERROR: UNEXPECTED PARSING ERROR FOR TABLE SYS.PARTLOB$

December 31, 2020

IDR 11.4.0.3-5582

APARs in IDR 11.4.0.3-5582 for Oracle

  • JR63083 WHEN THE SAME TABLE IS USED IN BOTH RULE BASED SUBSCRIPTION AND STATIC MAPPING, THE ALTER TABLE ADD <COLUMN> STATEMENT WOULD BE SENT TO BOTH TARGETS, CAUSING ERROR ON THE TARGET OF THE STATIC MAPPING SUBSCRIPTION
  • JR63139 LOG PARSER THROWS ARRAYINDEXOUTOFBOUNDSEXCEPTION
  • JR63155 SUBSCRIPTION FAILS AFTER "UNEXPECTED HISTORY ACTION TRANSITION ALTER_TABLE TO DROP_PARTITION"
  • JR63099 REPORT PRIMARY INDEX AND UNIQUE INDEX WHEN CHANGED FROM CHCCLP LIST TABLE INDEX COMMAND

December 3, 2020

IDR 11.4.0.3-5576

Enhancements in IDR 11.4.0.3-5576 for Oracle

  • CDC for Oracle (redo) will now provide Journal Control Field &USER by extracting that information from Oracle redo log instead of occasionally using internal session history db
  • The dmsupportinfo command line utility now dumps and collects configuration metadata in a text format

APARs in IDR 11.4.0.3-5576 for Oracle

  • JR62333 IIDR ORACLE IN DATAGUARD SHIPPING MODE USING THE STANDBY QUERY MAY STILL TRANSFORM THE ARCHIVE LOG FILE NAME AND PATH.
  • JR62982 IDR IS FAILING ARRAYINDEXOUTOFBOUND EXCEPTION WHEN UPDATE IS LOGGED AS QUICK MULTI DELETE AND INSERT.
  • JR63056 IDR ORACLE FASTLOAD REFRESH CAN FAIL WITH ORA-12154 ERROR IF THE TNSNAMES.ORA FILE IS IN A DIFFERENT LOCATION THAN $ORACLE_HOME/NETWORK/ADMIN DIRECTORY
  • JR62920 EXCESSIVE DIAGNOSTIC PROBES FOR TRUNCATE OF CLOB EVENTS

Bug fixes in IDR 11.4.0.3-5576 for Oracle

  • IDR now truncates LOB data precisely based on the value of the userexit_max_lob_size_kb parameter instead of exceeding the maximum size for some values
 

November 5, 2020

IDR 11.4.0.3-5572

Enhancements in IDR 11.4.0.3-5572 for Oracle

  • EVENT THAT ALERTS USER THAT IDR HAS DETECTED A DDL NOW INCLUDES THE DDL TEXT IF LOGGING OF DDL STATEMENTS IS ENABLED

APARs in IDR 11.4.0.3-5572 for Oracle

  • JR62828 INSERT A NULL TO AN EDT COLUMN COULD TRIGGER THE ASSERTION FAILURE.
  • JR62882 WHEN REPLICATING EDT COLUMN, CDC COULD INCORRECTLY INCLUDE THE 30 LEADING BYTES THAT SHOULD BE TRUNCATED FOR UPDATE OPERATIONS
  • JR62909 INCORRECT SAMPLE CONTENT WHEN ISSUING "DMEXPORTCONFIGURATION -?"
  • JR62934 DMTS64 NOT RELEASING IX (EXCLUSIVE) LOCK ON SYSTABLES AFTER MAKING DATABASEMETADATA CALLS

Bug fixes in IDR 11.4.0.3-5572 for Oracle

  • &LIBRARY, &MEMBER and &OBJECT Journal Control Fields now evaluate to the correct values instead of an empty string when used in a derived column
  • JR62973 IDR IS NOT POPULATING JCF FIELDS FOR START AND END REFRESH EVENTS WHEN USEREXIT USED

November 5, 2020

IDR 11.4.0.3-5570

Enhancements in IDR 11.4.0.3-5570 for Oracle

  • The dmsupportinfo command line utility now collects trace files significantly faster
  • The dmsupportinfo command line utility now collects all available trace files, performance statistics and events when you do not use the "-t" property to specify a time range

APARs in IDR 11.4.0.3-5570 for Oracle

  • JR62613 PRIMARY KEY NOT GETTING UPDATED IN TABLE PROPERTIES
  • JR62799 MIRRORING DOES NOT ENTER FAILED STATE WHEN IT DETECTS A DDL OCCURRED ON A STATIC TABLE
  • JR62787 USER GETS A DUPLICATE KEY EXCEPTION IF THEY HAVE A TABLE MAPPING WITH TWO OR MORE COLUMNS WITH A COMMENT THAT IS THE SAME FOR THE FIRST 260 CHARACTERS

Bug fixes in IDR 11.4.0.3-5570 for Oracle

  • Addressed a defect in the dmsupportinfo command line utility that caused trace files to be omitted during collection

September 2, 2020

IDR 11.4.0.3-5569

APARs in IDR 11.4.0.3-5569 for Oracle

  • JR62730 CDC FOR ORACLE CAN SOMETIMES APPEND EXTRA 0X00(S) TO THE EDT COLUMNS

August 28, 2020

IDR 11.4.0.3-5567

APARs in IDR 11.4.0.3-5567 for Oracle

  • JR62646 FIXED REMOTE LOG READING ERROR: FILE NOT FOUND EXCEPTION FOR NON ASM SETUP
  • JR62737 CDC ERROR 9506 OCCURS AFTER A DDL EVEN WHEN ALL DDL PROCEDURES ARE FOLLOWED

Bug fixes in IDR 11.4.0.3-5567 for Oracle

  • Fixed Array Index Out of Bounds Exception or Null Pointer Exception occurring when operation from shared scrape staging store needs a table definition that is older than the current table definition

July 30, 2020

IDR 11.4.0.3-5566

Enhancements in IDR 11.4.0.3-5566 for Oracle

  • 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.4.0.3-5566 for Oracle

  • JR62496 IDR (IN SOME CASES) DOES NOT REPLICATE, FROM MANUALLY ADDED ORACLE TABLE PARTITIONS
  • JR62569 IDR FAILS TO REPLICATE SUBQUERY INSERTS ON ORACLE, WITH COMPATIBLE VERSION 12.2 AND ABOVE.
  • JR62552 AN EMPTY STRING REPLICATED FROM A NON-ORACLE SOURCE DATABASE TO AN ORACLE TARGET DATABASE EXTENDED VARCHAR/NVARCHAR COLUMN BECOMES NULL.
  • JR62553 AN EMPTY VALUE REPLICATED FROM A NON-ORACLE SOURCE DATABASE TO AN ORACLE TARGET DATABASE RAW COLUMN BECOMES NULL.
  • JR62554 AN EMPTY VALUE REPLICATED FROM A NON-ORACLE SOURCE DATABASE TO AN ORACLE TARGET DATABASE BLOB COLUMN IS INSERTED AS A SINGLE BYTE WITH THE VALUE 0.
  • JR62595 CDC CAN THROW NULLPOINTEREXCEPTION WHEN TRYING TO RETRIEVE ROWID FOR LOB COLUMN OF THE TABLE
  • JR62628 INDEX OUT OF BOUNDS EXCEPTION CAN OCCUR AT DBCONNECTIONMANAGER.RELEASEMETADATASESSION()

July 8, 2020

IDR 11.4.0.2-5564

APARs in IDR 11.4.0.2-5564 for Oracle

  • JR62378 ADDED SUPPORT TO ENABLE REMOTE ORACLE AFD

June 30, 2020

IDR 11.4.0.2-5563

Enhancements in IDR 11.4.0.2-5563 for Oracle

  • IDR will no longer execute any query against oracle database while registering archived log file using dmarchivedlogavailable command.

APARs in IDR 11.4.0.2-5563 for Oracle

  • JR62451 IDR REPLICATES SOURCE DERIVED COLUMN DATA TO INCORRECT TARGET COLUMN

May 28, 2020

IDR 11.4.0.2-5560

Enhancements in IDR 11.4.0.2-5560 for Oracle

  • Instance-specific command line utilities now trace their parameters and an execution return code.

APARs in IDR 11.4.0.2-5560 for Oracle

  • JR62258 CDC INCORRECTLY DECLARES TABLE DEFINITION CHANGE WHEN PROCESSING AN INSERT OPERATION ON TABLECONTAINING EDT COLUMNS
  • JR62319 IIDR ORACLE TRYING TO GET EDT DATA EVEN WHEN THE DATA WEREN'T PRESENT AND HIT ASSERTION.NECESSITYEXCEPTION

Bug fixes in IDR 11.4.0.2-5560 for Oracle

  • dmconfigurets now correctly shows a list of innaccessible mount point overrides.
  • IDR will no longer log excessive tracing of NonTransientConnectionException by avoiding rolling back a transaction on a database connection that has auto-commit enabled.
  • dmconfigurets no longer creates two trace files when run in the command line mode.

April 23, 2020

IDR 11.4.0.2-5548

APARs in IDR 11.4.0.2-5548 for Oracle

  • JR62183 FIXED IDR REPLICATING ADDITIONAL DATA FOR ORACLE EDT COLUMN FOR DATA ABOVE 255 BYTES.
  • JR62178 IIDR ORACLE MAY NOT CORRECTLY DECRYPT BEGIN TXN ENTRIES WHEN TDE IS ENABLED
  • JR62250 APPLY TO ORACLE CAN FAIL WITH AN INVALID NUMBER EXCEPTION

April 7, 2020

IDR 11.4.0.2-5544

Enhancements in IDR 11.4.0.2-5544 for Oracle

  • IDR for Oracle now supports AFD ( ASM Filter Driver)
  • dmsupportinfo no longer collects duplicate information in the "dir.txt" support assistant file when an instance folder is inside the product installation directory.

APARs in IDR 11.4.0.2-5544 for Oracle

  • JR61925 CDC COULD INCORRECTLY DECLARE TABLE DEFINITION HAS BEEN CHANGED WHEN PROCESSING A DELETE OPERATION ON TABLE CONTAINING EDT COLUMNS
  • JR61932 DEADLOCK MAY OCCUR IN CASE OF SIMULTANEOUS ACTION TO DELETE A SUBSCRIPTION AND TO START A DIFFERENT SUBSCRIPTION
  • JR62009 IDR FOR ORACLE ON ORACLE 19C, IS LOGGING MULTIPLE INTERNAL ERROR EVENTS.
  • JR62068 IDR FOR ORACLE FAILS WHILE CREATING INSTANCE WITH ORACLE 19.6 WITH ERROR MUNMAP_CHUNK(): INVALID POINTER AND GENERATE CORE DUMP.
  • JR62126 IMPROVED IDR COMMAND LINE UTILITIES PERFORMANCE BY OPTIMIZING ACCESS TO CDC SECRET STORE WHEN ENGINE-TO-ENGINE ENCRYPTION IS DISABLED, ENABLED OR REQUIRED.
  • JR62158 SCHEDULED END BY TIME SOMETIMES DOESN'T WORK WHEN DB IS 100% IDLE, SHARED SCRAPE IS USED AND SUBSCRIPTION FINDS NEW OPERATIONS IN STAGING STORE AT STARTUP.

Bug fixes in IDR 11.4.0.2-5544 for Oracle

  • Addressed the error "row already exist in index TABLE_NAMES_IDENTITY_NAME_IDX" when accessing the metadata
  • Addressed intermittent "java.lang.AssertionError thread interruption is not supported" in TraceFormatter.
  • Instance commands no longer create trace files in "installation_directory/log".
 

February 20, 2020

IDR 11.4.0.2-5528

Enhancements in IDR 11.4.0.2-5528 for Oracle

  • JDBC Driver for Oracle has been updated from 5.1.4.000453 to 6.0.0.000134
  • IDR now closes some idle database connections and re-opens them as needed. The global_database_connection_idle_timeout_seconds system parameter controls how long to keep idle database connections open. Closing idle database connections before firewalls close them prevents subscriptions from stopping due to broken database connections.

APARs in IDR 11.4.0.2-5528 for Oracle

  • JR61910 IDR ORACLE READ ONLY INSTANCE IS NOT EXPORTED PROPERLY USING TSEXPORTCONFIGURATION COMMAND WHICH LEAD TO ERROR WHILE IMPORTING THAT XML
  • JR61921 JORD CAN ABORT WHEN PROCESSING ONLINE LOG FOR A CLOSED NODE IN RAC
  • JR61919 CDC TARGET CAN LEAK ORACLE SESSIONS
  • JR61900 INFOSPHERE DATA REPLICATION FOR ORACLE CAN FAIL TO DECRYPT TRANSACTION ID INFO FROM BEGIN/COMMIT ENTRIES WHEN TDE ENABLED.
  • JR61976 IDR SENT DATA TO THE ORACLE TARGET DATABASE IN THE JDBC DRIVER ENCODING INSTEAD OF THE USER OVERRIDDEN ENCODING
  • JR61841 ERROR REFRESHING A TABLE WITH A LONG COLUMN COMMENT: "AN UNCAUGHT EXCEPTION HAS OCCURRED"

Bug fixes in IDR 11.4.0.2-5528 for Oracle

  • Addressed "No more data available to read" and "Connection reset by peer" errors in the log reader when a remote database connection is idle for longer than the firewall allows.
  • IDR automatically recovers an erroneous metadata state that could cause lead to "An error has occurred. Possible recovery steps: Please try again. If the error persists, if possible restart the IBM Data Replication instance and try again. Internal error information: Agent Message 'Message3036' Exception text 'null'"
  • Improved reliability when global_subscription_level_connection_keep_alive_seconds is set to a non-zero value.
  • IDR now uses a different method to manipulate metadata table TABLE_NAMES_IDENTITY that is expected to prevent metadata corruption involving this table. This corruption could lead to the inability to use a table mapping or even delete it.
  • Addressed intermittent EOFException and SocketException when running command line utilities under stress.
  • Addressed intermittent EOFException reported by Agent Reader thread when using command line utilities.

January 21, 2020

IDR 11.4.0.2-5522

Enhancements in IDR 11.4.0.2-5522 for Oracle

  • IDR for oracle now supports oracle ADWC/OLTP as target.
  • IDR issues an improved error message when dmconfigurets is run with non-Administrator privileges in Windows Server 2016

APARs in IDR 11.4.0.2-5522 for Oracle

  • JR61828 CREATE INDEX DDL FAILS, IF IT IS ALTERED AS UNUSABLE DURING RULE-BASED REFRESH.
  • JR61803 IIDR FAILS WITH ERROR TOO MANY OPEN FILE DESCRIPTOR WHEN MULTIPLE INSTANCES ARE RUNNING FROM SAME INSTALLATION BECAUSE OF FILE DESCRIPTOR LEAK.

December 19, 2019

IDR 11.4.0.2-5521

APARs in IDR 11.4.0.2-5521 for Oracle

  • APAR JR61779 CDC (ORACLE REDO) CAN HAVE PARSER FAILURE WHEN ONLY REDO LOG ENTRY IS ENCRYPTED

November 27, 2019

IDR 11.4.0.2-5512

Enhancements in IDR 11.4.0.2-5512 for Oracle

  • IIDR now supports always encrypting communication with TLS, without negotiation. This feature may be enabled by setting Engine-to-Engine Communication Encryption to Always in the encryption profile. When this feature is enabled, IIDR will not be able to communicate with source datastores, target datastores, or Access Servers that negotiate encryption through STARTTLS.
  • IDR no longer raises an error event if it cannot extract primary index information for a table from the database

APARs in IDR 11.4.0.2-5512 for Oracle

  • JR60590 AFTER REFRESH USER EXIT IS NOT EXECUTED FOR JOURNAL CONTROL CODE FIELD.
  • JR61391 CDC FOR ORACLE REFRESH USING FAST LOAD CAN GET: BUFFER SIZE IS TO SMALL TO HOLD FORMATTED COLUMNS DATA.
  • APAR JR61737 IIDR IS GETTING NPE WHILE PROCESSING DATA OF VIEW SYS.TAB$ COLUMN FILE# AND BLOCK#
  • JR61637 CDC STILL TAKES VALUES IN BYTES AFTER CHANGING SYSTEM PARAMETER USEREXIT_MAX_LOB_SIZE_KB UNLESS THE INSTANCE IS RESTARTED

Bug fixes in IDR 11.4.0.2-5512 for Oracle

  • Trace can now be collected reliably using support assistant in concurrent invocations.
  • Addressed differential refresh failing when order of columns in primary key differs from order returned by JDBC

October 31, 2019

IDR 11.4.0.2-5507

Enhancements in IDR 11.4.0.2-5507 for Oracle

  • dmsupportinfo command line utility collects replication product traces using an optimized algorithm to speed up data collection

APARs in IDR 11.4.0.2-5507 for Oracle

  • JR61491 CDC CAN HIT NULLPOINTEREXCEPTION WHEN IT WAS PROCESSING AN ASM MANAGED REDO LOG
  • JR61591 WHEN CREATING AN INSTANCE WITH 11.4.0.2-5130 BUILD, A WARNING MESSAGE APPEARS INDICATING EDT IS UNSUPPORTED.
  • JR61590 IIDR FOR ORACLE IS NOT ABLE TO REPLICATE ENCRYPTED DATA FOR TABLESPACE ENCRYPTION ON AIX.

September 27, 2019

IDR 11.4.0.2-5506

Enhancements in IDR 11.4.0.2-5506 for Oracle

  • IDR now support Oracle SecureFile LOB.
  • IDR CDC product binaries are signed with a new signing service and with an updated certificate with expiry date "Wed Jun 30 08:00:00 2021"
  • IIDR now supports dmcreateencryptionprofile for creating encryption profiles.

APARs in IDR 11.4.0.2-5506 for Oracle

  • JR61440 CDC THROWS NPE WHEN THE RETURN TYPE OF THE STORED PROCEDURE IS USED IN DATE/TIMESTAMP, AND THE VALUE RETURN IS NULL
  • JR61452 IIDR IS PROCESSING ORACLE REDO LOG FILE VERY SLOWLY WHEN IT IS READING REDO LOG FILE OF SIZE MORE THAN 4GB

September 10, 2019

IDR 11.4.0.2-5503

Enhancements in IDR 11.4.0.2-5503 for Oracle

  • IDR for oracle now supports oracle 19c for source engines as well as target engines
  • Prior product libraries found in /lib are deleted when upgrading product binaries before new libraries are dropped on disk. All jar files with names similar to those installed with the product will be deleted.
  • IIDR now supports the option of requiring TLS encryption for all connections from Access Server and other datastores.

APARs in IDR 11.4.0.2-5503 for Oracle

  • JR61369 IBM DATA REPLICATION HITS A NULLPOINTEREXCEPTION WHEN NO ARCHIVE LOG LOG IS PRESNT IN V$ARCHIVED_LOG FOR A SPECIFIC RAC NODE AT LOG READING POSITION
  • JR61355 CREATEUSER-ORA-NODBA.SQL SAMPLE SCRIPT DOESN’T CONTAIN PERMISSION GRANT FOR UNLIMITED TABLESPACE BUT IT IS ONE OF THE MANDATORY PRIVILEGE REQUIRED BY CDC ENGINE.
  • JR61360 DMSET COMMANDS THROWS NULLPOINTER EXCEPTION IN MANUAL LOG SHIPPING.
  • JR61350 CDC IS FAILING WITH REDO LOG NOT FOUND ERROR IN MANUAL LOG SHIPPING WHEN IT IS CONFIGURED WITH PRIMARY SYSTEM HAVING RAC+ASM.
  • JR61380 "ARITHMETICEXCEPTION DIVIDE BY 0" IS THROWN WHEN ONLY DERIVED COLUMN ARE SET FOR REPLICATION

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Version":"All Versions"}]

Product Synonym

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

Document Information

Modified date:
22 December 2025

UID

ibm16217954

Page Feedback