Release Notes for IDR 11.4 for Microsoft SQL Server

IDR 11.4.0.5-5788

Enhancements in IDR 11.4.0.5-5788 for CDC Replication Engine for Microsoft SQL Server

• Dmshowversion command output now includes Java version

Known Issues fixed in IDR 11.4.0.5-5788 for CDC Replication Engine for Microsoft SQL Server

• DT448348 CDC Replication Engines do not set JVM parameter -Xms after saving configuration (Announcement only, KT already closed)
• DT456860 CDC Replication Engine targets - refresh performance can be lower when using multiple image builder threads

IDR 11.4.0.5-5785

Bugs fixed in IDR 11.4.0.5-5785 for CDC Replication Engine for Microsoft SQL Server

• 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

IDR 11.4.0.5-5783

Enhancements in IDR 11.4.0.5-5783 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.5-5776

Enhancements in IDR 11.4.0.5-5776 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.5-5770

Enhancements in IDR 11.4.0.5-5770 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.5-5768

Enhancements in IDR 11.4.0.5-5768 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.5-5765

Enhancements in IDR 11.4.0.5-5765 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• Non inline LOBs in a JDBC batch are not closed

IDR 11.4.0.5-5757

Enhancements in IDR 11.4.0.5-5757 for CDC Replication Engine for Microsoft SQL Server

• 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

IDR 11.4.0.5-5752

Enhancements in IDR 11.4.0.5-5752 for CDC Replication Engine for Microsoft SQL Server

• IDR now supports AlwaysOn with Microsoft SQL Server 2022. Supported from 11.4.0.4-5676.
• 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 Microsoft SQL Server

• DT425620 CDC Replication Engine for Microsoft SQL Server - Capture Table based configuration has high tempdb usage and many preparedstatements left open

IDR 11.4.0.5-5742

Enhancements in IDR 11.4.0.5-5742 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

• DT419421 CDC Replication Engines - command line utilities might not properly negotiate TLS settings with the local engine

IDR 11.4.0.5-5740

Enhancements in IDR 11.4.0.5-5740 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.5-5733

Enhancements in IDR 11.4.0.5-5733 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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

IDR 11.4.0.5-5730

Enhancements in IDR 11.4.0.5-5730 for CDC Replication Engine for Microsoft SQL Server

• 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

IDR 11.4.0.5-5726

Enhancements in IDR 11.4.0.5-5726 for CDC Replication Engine for Microsoft SQL Server

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

IDR 11.4.0.5-5725

Enhancements in IDR 11.4.0.5-5725 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• CDC Replication Engine for Microsoft SQL Server now supports sourcing change data from SQL Server capture tables
• IDR now supports replicating from a database with log compression enabled with Capture Table based configuration
• IDR now supports replicating from a Transparent data encryption(TDE) enabled database with Capture Table based configuration
• IDR now supports replicating from an online remote source with Capture Table based configuration
• IDR now supports Azure SQL Database as source with Capture Table based configuration
• IDR now supports Microsoft SQL Databases using third party backup tools as source with Capture Table based configuration
• IDR now supports Azure SQL Managed Instance as source with Capture Table based configuration
• CDC now supports custom character sets that map multiple byte sequences to the same Unicode character.

IDR 11.4.0.5-5715

Enhancements in IDR 11.4.0.5-5715 for CDC Replication Engine for Microsoft SQL Server

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

IDR 11.4.0.5-5706

Enhancements in IDR 11.4.0.5-5706 for CDC Replication Engine for Microsoft SQL Server

• 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

Bugs fixed in IDR 11.4.0.5-5706 for CDC Replication Engine for Microsoft SQL Server

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

IDR 11.4.0.5-5703

Enhancements in IDR 11.4.0.5-5703 for CDC Replication Engine for Microsoft SQL Server

• Effective February 2024, IDR CDC will no longer provide support for Microsoft SQL Server 2014
• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• Added ParallelizeByHash, ParallelizeByHashNetEffect, and ParallelizeByHashNetEffectConvertUpdates fast apply algorithms

Bugs fixed in IDR 11.4.0.5-5702 for CDC Replication Engine for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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

IDR 11.4.0.5-5699

Known Issues fixed in IDR 11.4.0.5-5699 for CDC Replication Engine for Microsoft SQL Server

• DT244777 When replicating data from Microsoft SqlServer using the CDC Replication Engine for Microsoft SqlServer, updates to source tables might not replicate to the target.

Bugs fixed in IDR 11.4.0.5-5699 for CDC Replication Engine for Microsoft SQL Server

• Fix incorrect product version shown in Windows program manager

IDR 11.4.0.5-5696

Enhancements in IDR 11.4.0.5-5696 for Microsoft SQL Server

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

Bug fixes in IDR 11.4.0.5-5696 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.4-5676

Enhancements in IDR 11.4.0.4-5676 for Microsoft SQL Server

• IDR now supports Microsoft SQL Server 2022. Support for AlwaysOn is not yet available.
• Added ParallelizeByTableNetEffect and ParallelizeByTableNetEffectConvertUpdates fast apply algorithms

IDR 11.4.0.4-5674

Enhancements in IDR 11.4.0.4-5674 for Microsoft SQL Server

• Updated JVMs to 8.0.8.0

APARs in IDR 11.4.0.4-5674 for Microsoft SQL Server

• 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 Microsoft SQL Server

• CDC now supports replication of before and after images of large objects up to the large object image length controlled by the system parameter "mssql_inline_lob_num_of_pages", by processing large object data found in database logs
• New derived expression %ORDERTAB(), to track per table record sequence number, is now supported on target agent.
• Updated JVMs to 8.0.7.20

Bug fixes in IDR 11.4.0.4-5672 for Microsoft SQL Server

• 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 Microsoft SQL Server

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

APARs in IDR 11.4.0.4-5670 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.4-5643

Enhancements in IDR 11.4.0.4-5643 for Microsoft SQL Server

• 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

Enhancements in IDR 11.4.0.4-5629 for Microsoft SQL Server

• Improved replication into tables that have identity column on the target in MS SQL

APARs in IDR 11.4.0.4-5629 for Microsoft SQL Server

• JR64572 NO WARNING EVENT WHEN CHARACTER DATA IS TRUNCATED

IDR 11.4.0.4-5627

Enhancements in IDR 11.4.0.4-5627 for Microsoft SQL Server

• Parallel Apply is now allowed with Adaptive Apply

APARs in IDR 11.4.0.4-5627 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• JR64618 DMTS64 PROCESS IS TAKING A LONGER TIME TO START

Bug fixes in IDR 11.4.0.4-5625 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• JR64490 IDR MAY FAIL WITH "INCORRECT SYNTAX" ERROR WHEN DATABASE NAME CONTAINS SPECICAL CHARACTERS WHEN USING FAST LOAD APPLY

IDR 11.4.0.4-5618

APARs in IDR 11.4.0.4-5618 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.4-5607

Bug fixes in IDR 11.4.0.4-5607 for Microsoft SQL Server

• Addressed an issue causing 'User does not have SELECT permission on the OBJECT named "distribution".dbo.MSPublications or it does not exist' when a user tries to install CDC with reduced privileges by using the 'grantuser-sql-nosa.sql' script against a case sensitive collated distribution database
• 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

APARs in IDR 11.4.0.4-5603 for Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.4-5602

Enhancements in IDR 11.4.0.4-5602 for Microsoft SQL Server

• IDR now excludes copy-only transaction logs by selecting backupset.is_copy_only!=1 when choosing transaction log backups for replication
• IDR now extracts metatada only about transaction logs backed up to disk by only including files from backupmediafamily.device_type=2 when choosing transaction log backups for replication

IDR 11.4.0.4-5599

Enhancements in IDR 11.4.0.4-5599 for Microsoft SQL Server

• Updated the Java Virtual Machine to IBM 8.0.6.30

APARs in IDR 11.4.0.4-5599 for Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.3-5596

Bug fixes in IDR 11.4.0.3-5596 for Microsoft SQL Server

• Fixed NecessityException in ChangeLogBlock on instance start up

IDR 11.4.0.3-5594

APARs in IDR 11.4.0.3-5594 for Microsoft SQL Server

• 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

IDR 11.4.0.3-5590

Enhancements in IDR 11.4.0.3-5590 for Microsoft SQL Server

• IDR no longer requires Microsoft SQL Server Management Studio (SMSS) or Microsoft SQL Server Management Objects (SMO) installed to drop and recreate indexes on SQL Server target tables.

IDR 11.4.0.3-5576

Enhancements in IDR 11.4.0.3-5576 for Microsoft SQL Server

• The dmsupportinfo command line utility now dumps and collects configuration metadata in a text format

APARs in IDR 11.4.0.3-5576 for Microsoft SQL Server

• JR62920 EXCESSIVE DIAGNOSTIC PROBES FOR TRUNCATE OF CLOB EVENTS

Bug fixes in IDR 11.4.0.3-5576 for Microsoft SQL Server

• 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

IDR 11.4.0.3-5572

Enhancements in IDR 11.4.0.3-5572 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.3-5570

Enhancements in IDR 11.4.0.3-5570 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.3-5567

APARs in IDR 11.4.0.3-5567 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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

IDR 11.4.0.3-5566

Enhancements in IDR 11.4.0.3-5566 for Microsoft SQL Server

• 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 Microsoft SQL Server

• JR62628 INDEX OUT OF BOUNDS EXCEPTION CAN OCCUR AT DBCONNECTIONMANAGER.RELEASEMETADATASESSION()

IDR 11.4.0.2-5563

APARs in IDR 11.4.0.2-5563 for Microsoft SQL Server

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

IDR 11.4.0.2-5560

Enhancements in IDR 11.4.0.2-5560 for Microsoft SQL Server

• IDR now supports Microsoft SQL Server 2019
• Instance-specific command line utilities now trace their parameters and an execution return code.

Bug fixes in IDR 11.4.0.2-5560 for Microsoft SQL Server

• CDC rolls back the transaction involving the sys.database_recovery_status table that is issued in archive only mode which prevents log_reuse_wait_desc in sys.databases to be ACTIVE_TRANSACTION
• dmconfigurets no longer creates two trace files when run in the command line mode.
• IDR will no longer log excessive tracing of NonTransientConnectionException by avoiding rolling back a transaction on a database connection that has auto-commit enabled.

IDR 11.4.0.2-5544

Enhancements in IDR 11.4.0.2-5544 for Microsoft SQL Server

• IDR is now able to replicate duplicate updates and deletes by limiting the modification to 1 row when applying data.
• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

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

IDR 11.4.0.2-5528

Enhancements in IDR 11.4.0.2-5528 for Microsoft SQL Server

• IDR has an enhanced code page detection algorithm that enables automatic database encoding detection for a larger set of code pages
• The JDBC driver has now been updated from version 5.1.4.000169 to 6.0.0.000263.
• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• IDR now prevents data loss when data is replicated by a private subscription scraper and new tables are added to the subscription after it has replicated other tables for some time
• 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.

IDR 11.4.0.2-5522

Enhancements in IDR 11.4.0.2-5522 for Microsoft SQL Server

• 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 Microsoft SQL Server

• JR61803 IIDR FAILS WITH ERROR TOO MANY OPEN FILE DESCRIPTOR WHEN MULTIPLE INSTANCES ARE RUNNING FROM SAME INSTALLATION BECAUSE OF FILE DESCRIPTOR LEAK.

IDR 11.4.0.2-5521

Enhancements in IDR 11.4.0.2-5521 for Microsoft SQL Server

• Microsoft Command Line Utilities 15.x for Microsoft SQL Server can now be used and is the preferred version for Azure SQL Database

IDR 11.4.0.2-5512

Enhancements in IDR 11.4.0.2-5512 for Microsoft SQL Server

• 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 Microsoft SQL Server

• 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 Microsoft SQL Server

• Addressed NullPointerException in configuration tool when testing AlwaysOn transaction log backup candidates in AlwaysOn configuration tab
• 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

IDR 11.4.0.2-5507

Enhancements in IDR 11.4.0.2-5507 for Microsoft SQL Server

• CDC uses dynamic online virtual log file discovery based on user authorization. Virtual log file discovery switches to DBCC LOGINFO when CDC configured user has a SYSADMIN role
• dmsupportinfo command line utility collects replication product traces using an optimized algorithm to speed up data collection

IDR 11.4.0.2-5506

Enhancements in IDR 11.4.0.2-5506 for Microsoft SQL Server

• 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 Microsoft SQL Server

• JR61535 CDC UPGRADE FAILS WITH MIGRATION ERROR WHEN USING INTEGRATED SECURITY

IDR 11.4.0.2-5503

Enhancements in IDR 11.4.0.2-5503 for Microsoft SQL Server

• 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 Microsoft SQL Server

• JR61375 POSSIBLE DATA LOSS AFTER EVENT ID 2903 "AN EXCEPTION HAS OCCURRED IN THE LOG PARSER."
• JR61380 "ARITHMETICEXCEPTION DIVIDE BY 0" IS THROWN WHEN ONLY DERIVED COLUMN ARE SET FOR REPLICATION

Bug fixes in IDR 11.4.0.2-5503 for Microsoft SQL Server

• NullPointerException in SectorGroupSlotArray no longer occurs on the first log block