Release Notes for IDR 11.4 for Oracle XStream

IDR 11.4.0.5-5733

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

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

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

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

IDR 11.4.0.5-5731

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

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

• 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

IDR 11.4.0.5-5730

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

• 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

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

IDR 11.4.0.5-5726

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

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

• DT390374 : CDC Replication Engine for Oracle XStream does not include the dmviewrepairsql command to display the Index DDL after failed Refresh

IDR 11.4.0.5-5725

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

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

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

IDR 11.4.0.5-5722

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

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

IDR 11.4.0.5-5721

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

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

• DT365579 CDC Replication Engine for Oracle XStream - &Timstamp JCF does not populate correctly after fix IDR 11.4.0.4-5644

IDR 11.4.0.5-5715

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

• IIDR for Oracle XStream can include in-line LOB data in row change without requiring query from source table. Available in IDR 11.4.0.5-5702 and newer.
• Document userexit interfaces such as UserExitIF, DataRecordIF and ReplicationEventIF in docs folder

APARs fixed in IDR 11.4.0.5-5715 for CDC Replication Engine for Oracle - XStream

• JR65375 IIDR ORACLE XSTREAM FAILS TLS HANDSHAKE TO ORACLE DATABASE 19C REQUIRING TCPS LISTENER CONNECTION

IDR 11.4.0.5-5706

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

• 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

IDR 11.4.0.5-5703

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

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

• 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

IDR 11.4.0.5-5702

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

• Added ParallelizeByHash, ParallelizeByHashNetEffect, and ParallelizeByHashNetEffectConvertUpdates fast apply algorithms

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

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

IDR 11.4.0.5-5700

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

• 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

IDR 11.4.0.5-5699

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

• Fix incorrect product version shown in Windows program manager

IDR 11.4.0.5-5696

Enhancements in IDR 11.4.0.5-5696 for Oracle - XStream

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

APARs in IDR 11.4.0.5-5696 for Oracle - XStream

• JR65343 IIDR ORACLE XSTREAM MAY SELECT INCOMPLETE BUILD POSITION TO BEGIN CAPTURE

Bug fixes in IDR 11.4.0.5-5696 for Oracle - XStream

• 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

IDR 11.4.0.4-5694

Enhancements in IDR 11.4.0.4-5694 for Oracle - XStream

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

IDR 11.4.0.4-5686

Enhancements in IDR 11.4.0.4-5686 for Oracle - XStream

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

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

IDR 11.4.0.4-5684

APARs in IDR 11.4.0.4-5684 for Oracle - XStream

• JR65275 CDC ORACLE XSTREAM INSTANCE DIES WITH OOM DUE TO POINTBASE METADATA CONNECTION LEAK
• JR65291 DUPLICATE KEY ERROR AFTER REFRESH USING FAST LOAD WITH CURSOR STABILITY ISOLATION LEVEL FROM DB2 Z/OS SOURCE TO ORACLE TARGET
• JR65292 INFOSPHERE DATA REPLICATION FOR ORACLE XSTREAM DOES NOT CORRECTLY COLLECT SUPPORTINFO ENDING WITH AN EXCEPTION : AN UNCAUGHT EXCEPTION HAS OCCURRED: JAVA.LANG.ASSERTIONERROR PROPERTY IS NOT APPLICABLE TO THIS PRODUCT: ORACLE_ASM_TNSNAMES_FILE| AT COM.DATAMIRROR.TS.PROPERTIES.MUTABLETSPROPERTIESPROVIDER.GETVALUEASOBJECTASIS(MUTABLETSPROPERTIESPROVIDER.JAVA:80)| AT COM.DATAMIRROR.TS.PROPERTIES.TSPROPERTIES.GETVALUEASOBJECTASIS(TSPROPERTIES.JAVA:9266)| AT COM.DATAMIRROR.TS.PROPERTIES.TSPROPERTIES.GETVALUEASOBJECT(TSPROPERTIES.JAVA:9275)|

IDR 11.4.0.4-5676

Enhancements in IDR 11.4.0.4-5676 for Oracle - XStream

• Added ParallelizeByTableNetEffect and ParallelizeByTableNetEffectConvertUpdates fast apply algorithms

IDR 11.4.0.4-5674

Enhancements in IDR 11.4.0.4-5674 for Oracle - XStream

• Updated JVMs to 8.0.8.0

APARs in IDR 11.4.0.4-5674 for Oracle - XStream

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

IDR 11.4.0.4-5672

Enhancements in IDR 11.4.0.4-5672 for Oracle - XStream

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

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

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

IDR 11.4.0.4-5670

Enhancements in IDR 11.4.0.4-5670 for Oracle - XStream

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

APARs in IDR 11.4.0.4-5670 for Oracle - XStream

• JR65239 CDC FOR ORACLE XSTREAM CAN'T HANDLE INVISIBLE COLUMN
• 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

IDR 11.4.0.4-5666

Enhancements in IDR 11.4.0.4-5666 for Oracle - XStream

• 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).

Bug fixes in IDR 11.4.0.4-5666 for Oracle - XStream

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

IDR 11.4.0.4-5661

Enhancements in IDR 11.4.0.4-5661 for Oracle - XStream

• JDBC batching is now allowed if target table before-operation user exits exist

IDR 11.4.0.4-5659

Enhancements in IDR 11.4.0.4-5659 for Oracle - XStream

• 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

IDR 11.4.0.4-5656

Enhancements in IDR 11.4.0.4-5656 for Oracle - XStream

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

• JR65145 CDC COMMAND DMFLAGFORREFRESH SHOULD NOT ALLOW TO USE DIFFERENTIAL REFRESH (-DR) OPTION IF TARGET ENGINE DOESN'T SUPPORT IT

IDR 11.4.0.4-5652

Enhancements in IDR 11.4.0.4-5652 for Oracle - XStream

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

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

IDR 11.4.0.4-5644

APARs in IDR 11.4.0.4-5644 for Oracle - XStream

• JR65089 CDC FOR ORACLE (XSTREAM) DOES NOT POPULATE THE &TIMESTAMP JOURNAL CONTROL FIELD CORRECTLY

IDR 11.4.0.4-5643

Enhancements in IDR 11.4.0.4-5643 for Oracle - XStream

• 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

IDR 11.4.0.4-5629

APARs in IDR 11.4.0.4-5629 for Oracle - XStream

• JR64572 NO WARNING EVENT WHEN CHARACTER DATA IS TRUNCATED

IDR 11.4.0.4-5627

Enhancements in IDR 11.4.0.4-5627 for Oracle - XStream

• Parallel Apply is now allowed with Adaptive Apply

APARs in IDR 11.4.0.4-5627 for Oracle - XStream

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

IDR 11.4.0.4-5625

Enhancements in IDR 11.4.0.4-5625 for Oracle - XStream

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

• JR64618 DMTS64 PROCESS IS TAKING A LONGER TIME TO START

Bug fixes in IDR 11.4.0.4-5625 for Oracle - XStream

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

IDR 11.4.0.4-5622

Enhancements in IDR 11.4.0.4-5622 for Oracle - XStream

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

IDR 11.4.0.4-5618

APARs in IDR 11.4.0.4-5618 for Oracle - XStream

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

IDR 11.4.0.4-5616

Enhancements in IDR 11.4.0.4-5616 for Oracle - XStream

• 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

IDR 11.4.0.4-5611

APARs in IDR 11.4.0.4-5611 for Oracle - XStream

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

IDR 11.4.0.4-5609

Enhancements in IDR 11.4.0.4-5609 for Oracle - XStream

• IDR performance has been improved by using the XStream native API. IDR now requires Oracle Client Patch 33147065 to replicate TIMESTAMP and INTERVAL data with precision of 7 or greater.

IDR 11.4.0.4-5607

Bug fixes in IDR 11.4.0.4-5607 for Oracle - XStream

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

IDR 11.4.0.4-5603

Enhancements in IDR 11.4.0.4-5603 for Oracle - XStream

• IDR now supports real-time downstream capture and archived-log downstream capture.

APARs in IDR 11.4.0.4-5603 for Oracle - XStream

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

• Subscriptions no longer fail with "opcode x is not mapped to a DataManipulationOperation type" after LOBs are manipulated with DBMS_LOB.
• Addressed an issue causing an OOM error if there are large number of trace files

IDR 11.4.0.4-5599

Enhancements in IDR 11.4.0.4-5599 for Oracle - XStream

• IDR for Oracle XStream supporting Oracle 19c with Transparent Data Encryption (TDE) and up to 128-character column and table names is now generally available.
• Updated the Java Virtual Machine to IBM 8.0.6.30

APARs in IDR 11.4.0.4-5599 for Oracle - XStream

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

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