Release Notes for IDR 11.4 for Google BigQuery

December 19, 2025

IDR 11.4.0.5-5789

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

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

• DT458318 CDC Replication Engine for BigQuery - table mapping fails when you select "Delete selected rows" option and provide a where clause in the operations tab of column mapping page

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

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

• Dmshowversion command output now includes Java version

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

• DT454645 CDC Replication Engine for BigQuery - delete operations fail because CDC is identifying Bignumeric column as numeric column during create temp table statement.
• DT456860 CDC Replication Engine targets - refresh performance can be lower when using multiple image builder threads

October 30, 2025

IDR 11.4.0.5-5785

Known issues fixed in IDR 11.4.0.5-5785 for CDC Replication Engine for BigQuery

• DT448348 CDC Replication Engines do not set JVM parameter -Xms after saving configuration

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

• CDC BigQuery subscriptions end on error for tables with column names containing reserved keywords
• 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 BigQuery

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

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

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

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

• DT449112 BigQuery instance fails to start with "Invalid password specified".
• 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 BigQuery

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

• Fixed an issue that prevented JSON files and credentials from being correctly loaded from the userexit during instance creation.
• 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 BigQuery

• IDR BigQuery now supports mapping CLOBs to Strings
• 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 BigQuery

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

• IDR now supports providing Google Credentials API through Userexit as a Object
• Updated JVM to 17.0.15.0, java version "17.0.15" 2025-04-15 IBM Semeru Runtime Certified Edition 17.0.15.0 (build 17.0.15+6). For details, see IBM Semeru Runtimes fixes for version 17

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

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

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

• DT431965 CDC Replication Engine for Google BigQuery - A delete can be lost when it is for a recent insert and is applied as part of the same Unit of Work (UOW) as the corresponding insert

April 4, 2025

IDR 11.4.0.5-5757

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

• Updated JVM to 17.0.14.0, java version "17.0.14" 2025-01-21 IBM Semeru Runtime Certified Edition 17.0.14.0 (build 17.0.14+7). For details, see IBM Semeru Runtimes fixes for version 17

February 28, 2025

IDR 11.4.0.5-5752

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

• Upgraded protobuf-java to 4.29.0
• Upgraded threetenbp to 1.7.0
• 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 BigQuery

• DT422429 CDC Replication Engine for BigQuery - Refresh ends on error when 'Database default value' is used for TIMESTAMP column

December 20, 2024

IDR 11.4.0.5-5742

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

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

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

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

• DT398056 CDC target Replication Engines - differential refresh log table name was generated incorrectly
• DT418168 CDC Replication Engines for Netezza, Db2 and BigQuery - NullPointerException thrown when calling a stored procedure, user exit or Mirror Bulk Apply (MBA)
• 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

Enhancements in IDR 11.4.0.5-5735 for CDC Replication Engine for BigQuery

• Support external secret store userexit for retrieving BigQuery service account JSON file

October 2, 2024

IDR 11.4.0.5-5733

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

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

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

• Management Console table mapping window does not display tables other than selected dataset during BigQuery instance creation
• 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 BigQuery

• Add ability for user to specify the string that will represent SQL NULL in the bigqueryloadoptions.xml file
• 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 BigQuery

• DT394553 CDC Replication Engines - subscription ends on error NullPointerException when a commit fails on the target engine
• 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 BigQuery

• BigQuery Bytes datatype now supported
• New lines in the column value now successfully replicate to BigQuery
• 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 BigQuery

• DT391703 CDC Replication Engine for BigQuery - Refresh fails when replicating double quotes as part of a column value
• DT392323 CDC Replication Engine for BigQuery - Many small units of work (UOW) are applied after a crash or abort stop if only one apply thread is configured

June 27, 2024

IDR 11.4.0.5-5726

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

• CDC Replication Engine for BigQuery now supports AIX
• CDC Replication Engine for BigQuery now enables preserve_ascii_control_characters in BigQuery load configuration. This helps to handle EBCDIC to UTF conversion.
• Effective January 2025, IDR CDC will no longer provide support for following operating system versions: RedHat Enterprise Linux (RHEL) 7; CentOS 7.x

Bugs fixed in IDR 11.4.0.5-5726 for CDC Replication Engine for BigQuery

• NullPointerException when BigQuery job failed.
• Assertion error when mapping to target BIGNUMERIC datatype.

June 4, 2024

IDR 11.4.0.5-5725

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

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

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

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

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

March 28, 2024

IDR 11.4.0.5-5715

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

• Allow CDC to trace BigQuery Errors while applying CSV file
• Document userexit interfaces such as UserExitIF, DataRecordIF and ReplicationEventIF in docs folder

Known Issues fixed in IDR 11.4.0.5-5715 for CDC Replication Engine for BigQuery

• DT363625 CDC Replication Engine for BigQuery - external table mirror bulk apply insert fails when the column value contains a CSV file delimiter

March 1, 2024

IDR 11.4.0.5-5706

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

• Allow CDC for BigQuery to create a single CSV file for refresh operation because bigquery has a limit of 1500 operations per day
• 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 BigQuery

• DT260363 CDC Replication Engine for BigQuery - Operations can be delayed getting applied after a abort/immediate stop or crash when using fast apply and some or all tables are refreshed before restarting

January 25, 2024

IDR 11.4.0.5-5703

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

• 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

Known Issues fixed in IDR 11.4.0.5-5703 for CDC Replication Engine for BigQuery

• DT259051 - CDC Replication Engine for BigQuery - Refresh ends on error "BigQueryException Error while reading data, error message: CSV processing encountered too many errors, giving up."

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

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

• Added ParallelizeByHash, ParallelizeByHashNetEffect, and ParallelizeByHashNetEffectConvertUpdates fast apply algorithms

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

• NecessityException if MBA is used and update before image is missing a column value
• 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 BigQuery

• 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

October 30, 2023

IDR 11.4.0.5-5699

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

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

• IDR now supports BigQuery as a target
• Updated JVM to 8.0.8.11, java version "1.8.0_381"