Fix Readme
Abstract
IBM Data Replication 11.4 Replication Engine release notes for Linux, Unix and Windows
Content
Navigate to release notes for specific IDR 11.4 LUW Replication Engines
Binaries are available on Fix Central
IDR 11.4.0.5-5725
Enhancements in IDR 11.4.0.5-5725
IDR 11.4.0.5-5725 for CDC for all LUW engines
- 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
IDR 11.4.0.5-5725 for CDC for all LUW engines
- DT382379 CDC Replication Engines - dmsupportinfo command does not collect complete details expected.
IDR 11.4.0.5-5722
Enhancements in IDR 11.4.0.5-5722
IDR 11.4.0.5-5722 for CDC Replication Engine for Db2 LUW
- Db2 LUW 11.5.9 and Db2 Warehouse 11.5.9 are now supported
- CDC Replication Engine for DB2 LUW improves handling Db2 readlog API transient compression errors. When reading from Db2 11.5.9 and newer, a source engine now retries reading the log, using new system parameters mirror_log_reader_timeout_retry_max and mirror_log_reader_timeout_retry_sleep_ms.
Known Issues fixed in IDR 11.4.0.5-5722
IDR 11.4.0.5-5722 for CDC for all LUW engines
- 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-5722 for CDC Replication Engine for PostgreSQL
- DT382103 CDC Replication Engine for PostgreSQL - Mirroring ends on error "No table context found" or no data replicates when LSN is large
IDR 11.4.0.5-5721
Enhancements in IDR 11.4.0.5-5721
IDR 11.4.0.5-5721 for CDC Replication Engine for Flexrep
- CDC now supports Snowflake JDBC Driver version 3.15.0
IDR 11.4.0.5-5721 for CDC Replication Engine for Kafka
- Upgraded kafka-client to 3.6.0 and schema-registry client to 7.6.0
- During lenient-tail functionality execution, added TCC retries and error handling when a Kafka cluster returns no records to a poll request to the commitstream topic with records
IDR 11.4.0.5-5721 for CDC for all LUW engines
- CDC now supports custom character sets that map multiple byte sequences to the same Unicode character.
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
Known Issues fixed in IDR 11.4.0.5-5721
IDR 11.4.0.5-5721 for CDC Replication Engine for Db2 LUW
- 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"
IDR 11.4.0.5-5721 for CDC Replication Engine for Db2 for z/OS remote source
- 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"
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"
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
Other changes in IDR 11.4.0.5-5721
IDR 11.4.0.5-5721 for CDC Replication Engine for Db2 for z/OS remote source
- DDL missed on in-scope table if the table was created in V7 or earlier and schema name length is less than 8 characters
IDR 11.4.0.5-5719
Known Issues fixed in IDR 11.4.0.5-5719
IDR 11.4.0.5-5719 for CDC Replication Engine for Db2 LUW
- DT365298 CDC Replication Engine for Db2 LUW - Replication ends on error "The table definition may have changed" when processing rolled-back operations that involved extended row record
- DT365914 CDC Replication Engine for Db2 LUW - Replication ends on error "BufferUnderFlowException log record of Info Only type"
IDR 11.4.0.5-5719 for CDC Replication Engine for Db2 for z/OS remote source
- DT269660 CDC Db2 for z/OS remote source - During refresh code conversion for the character set x-IBM300 was performed incorrectly
IDR 11.4.0.5-5715
Enhancements in IDR 11.4.0.5-5715
IDR 11.4.0.5-5715 for CDC Replication Engine for BigQuery
- Allow CDC to trace BigQuery Errors while applying CSV file
IDR 11.4.0.5-5715 for CDC Replication Engine for Db2 LUW
- CDC Replication Engine for Db2 LUW supports Db2 Warehouse on RedHat OpenShift Container Platform as both a source and a target
- CDC Replication Engine for Db2 LUW supports RedHat Enterprise Linux (RHEL) 8 POWER System - Little Endian
IDR 11.4.0.5-5715 for CDC Replication Engine for Kafka
- TCC consumer now has individual default names for collecting JMX statistics. Preserve the original consumer name using the "client.id" consumer property.
IDR 11.4.0.5-5715 for CDC for all LUW engines
- Document userexit interfaces such as UserExitIF, DataRecordIF and ReplicationEventIF in docs folder
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.
APARs fixed in IDR 11.4.0.5-5715
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
Known Issues fixed in IDR 11.4.0.5-5715
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
IDR 11.4.0.5-5715 for CDC Replication Engine for Kafka
- DT255108 IDR CDC Kafka - KcopSingleRowAvroAuditIntegrated throws Invalid Schema Modification error when the column is a not-nullable CLOB with default value
IDR 11.4.0.5-5715 for CDC Replication Engine for MySQL source
- DT270157 CDC Replication Engine for MySQL source - mirroring fails with a Log Reader NullPointerException error when it encounters an IGNORABLE event before the first GTID event in the log
IDR 11.4.0.5-5707
Known Issues fixed in IDR 11.4.0.5-5707
IDR 11.4.0.5-5707 for CDC Replication Engine for Db2 for z/OS remote source
- DT271515 CDC Replication Engine Db2 for z/OS remote source - Replication ends on error "TsDatatype cannot be null. Unable to find Tsdatatype for table"
IDR 11.4.0.5-5706
Enhancements in IDR 11.4.0.5-5706
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
IDR 11.4.0.5-5706 for CDC Replication Engine for Db2 LUW
- CDC Replication Engine for Db2 LUW now supports API (IAM) key authentication method
IDR 11.4.0.5-5706 for CDC for all LUW engines
- 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-5706 for CDC Replication Engine for PostgreSQL
- CDC Replication Engine for PostgreSQL supports Fastload Refresh
Known Issues fixed in IDR 11.4.0.5-5706
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
IDR 11.4.0.5-5706 for CDC Replication Engine for Db2 LUW
- DT261836 CDC Replication Engine for Db2 LUW - Db2 LUW CPU increased when the source database was otherwise idle
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
IDR 11.4.0.5-5706 for CDC Replication Engine for PostgreSQL
- DT260417 CDC Replication Engine for PostgreSQL - Partitioned tables in a schema are not listed after upgrading to IDR 11.4.0.4-5676 through 11.4.0.5-5703
- DT269669 CDC Replication Engine for PostgreSQL - wrong data replicates for columns that follow an XML column
Bugs fixed in IDR 11.4.0.5-5706
IDR 11.4.0.5-5706 for CDC Replication Engine for Db2 LUW
- NecessityException could occur when running a table level user exit with any of the parallel hash fast apply algorithms
IDR 11.4.0.5-5706 for CDC Replication Engine for Informix
- NecessityException could occur when running a table level user exit with any of the parallel hash fast apply algorithms
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
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-5706 for CDC Replication Engine for Sybase
- NecessityException could occur when running a table level user exit with any of the parallel hash fast apply algorithms
IDR 11.4.0.5-5706 for CDC Replication Engine for Teradata
- 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
IDR 11.4.0.5-5703 for CDC for all LUW engines
- 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
IDR 11.4.0.5-5703 for CDC Replication Engine for MariaDB source
- Support replicating from binary logs having mixed GTID
IDR 11.4.0.5-5703 for CDC Replication Engine for MySQL source
- Support replicating from binary logs having mixed GTID
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
IDR 11.4.0.5-5703 for CDC Replication Engine for Oracle Trigger
- Effective February 2024, IDR CDC will no longer provide support for Oracle 11g and 12.1
IDR 11.4.0.5-5703 for CDC Replication Engine for PostgreSQL
- Effective February 2024, IDR CDC will no longer provide support for PostgreSQL 9.4, 9.5, 9.6
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
IDR 11.4.0.5-5703 for CDC Replication Engine for Teradata
- Effective February 2024, IDR CDC will no longer provide support for Teradata 14.x, 15.x
APARs fixed in IDR 11.4.0.5-5703
IDR 11.4.0.5-5703 for CDC Replication Engine for PostgreSQL
- DT258966 IIDR CDC FOR POSTGRESQL FAILS WITH TABLE CONTEXT NOT FOUND ERROR
Known Issues fixed in IDR 11.4.0.5-5703
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
IDR 11.4.0.5-5703 for CDC for all LUW engines
- 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-5703 for CDC Replication Engine for PostgreSQL
- DT258966 IIDR CDC FOR POSTGRESQL FAILS WITH TABLE CONTEXT NOT FOUND ERROR
- CDC for PostgreSQL fails to map table with a decimal column with no precision
Other changes in IDR 11.4.0.5-5703
IDR 11.4.0.5-5703 for CDC for all LUW engines
- Deadlock/timeout, row-not-found, or duplicate key exceptions are possible if key is updated and ParallelizeByHashNetEffect fast apply algorithm is being used
IDR 11.4.0.5-5702
Enhancements in IDR 11.4.0.5-5702
IDR 11.4.0.5-5702 for CDC Replication Engine for Db2 for z/OS remote source
- CDC now supports Db2 z/OS with PH53641
IDR 11.4.0.5-5702 for CDC Replication Engine for Event Server
- CDC Replication Engine for Event Server is now available in 11.4.0.5
IDR 11.4.0.5-5702 for CDC Replication Engine for Kafka
- Set PARTITION_AUTO to dynamically detect the number of partitions of the topic currently writing to
IDR 11.4.0.5-5702 for CDC for all LUW engines
- Added ParallelizeByHash, ParallelizeByHashNetEffect, and ParallelizeByHashNetEffectConvertUpdates fast apply algorithms
Known Issues fixed in IDR 11.4.0.5-5702
IDR 11.4.0.5-5702 for CDC Replication Engine for Db2 LUW
- DT255186 Db2 Luw Purescale HOL report position bookmark commit positions can go backwards.
- DT255188 Db2 Luw Data loss possible if database is 100% idle while the log reader is running and is at HOL, and then in-scope operations are the first operations performed.
IDR 11.4.0.5-5702 for CDC Replication Engine for PostgreSQL
- DT256954 CDC fails to parse an update operation when a non-null bytea column value is unchanged
Bugs fixed in IDR 11.4.0.5-5702
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
IDR 11.4.0.5-5702 for CDC Replication Engine for Db2 LUW
- NecessityException if MBA is used and update before image is missing a column value
- Duplicate key or IndexOutOfBounds exceptions can occur upon subscription restart if exception occurs on the target applying a DML after applying a homogenous DDL in the same transaction
IDR 11.4.0.5-5702 for CDC Replication Engine for Db2 for z/OS remote source
- Replication occasionally fails with IFI error E60865 after upgrading to build 5679 or newer, even with the fix in build 5694
IDR 11.4.0.5-5702 for CDC for all LUW engines
- Specifying the number of image builder threads via the NullMirrorOptimizer fast apply user exit causes subscription to stop
IDR 11.4.0.5-5702 for CDC Replication Engine for Netezza
- NecessityException if MBA is used and update before image is missing a column value
IDR 11.4.0.5-5700
Enhancements in IDR 11.4.0.5-5700
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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Db2 LUW
- 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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Db2 for z/OS remote source
- CDC Db2 for z/OS remote source is now able to avoid getting a shared table lock at the start of a refresh if CDC system property refresh_avoid_instant_table_lock_if_possible is true and the Db2z SKIPUNCI subsystem parameter is NO
IDR 11.4.0.5-5700 for CDC Replication Engine for Flexrep
- 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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Informix
- 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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Kafka
- Upgraded kafka-client to 3.5.1 and schema-registry client to 7.5.1
IDR 11.4.0.5-5700 for CDC for all LUW engines
- Updated various open source libraries
IDR 11.4.0.5-5700 for CDC Replication Engine for Netezza
- 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.
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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Oracle Trigger
- 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.
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.
IDR 11.4.0.5-5700 for CDC Replication Engine for PostgreSQL
- IDR CDC for PostgreSQL supports DDL awareness
- 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.
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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Sybase
- 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.
IDR 11.4.0.5-5700 for CDC Replication Engine for Teradata
- 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.
Known Issues fixed in IDR 11.4.0.5-5700
IDR 11.4.0.5-5700 for CDC Replication Engine for MariaDB source
- DT246760 Added system parameter based retry for MySQL/MariaDB binary log wait interval.
IDR 11.4.0.5-5700 for CDC Replication Engine for MySQL source
- DT246760 Added system parameter based retry for MySQL/MariaDB binary log wait interval.
Bugs fixed in IDR 11.4.0.5-5700
IDR 11.4.0.5-5700 for CDC Replication Engine for Db2 LUW
- 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
- NecessityException if external table mirror bulk apply is used and update before image is missing a column value
IDR 11.4.0.5-5700 for CDC Replication Engine for Informix
- 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-5700 for CDC Replication Engine for MariaDB source
- Event log does not print correct start position for new consecutive binary log file read
IDR 11.4.0.5-5700 for CDC Replication Engine for MySQL source
- Event log does not print correct start position for new consecutive binary log file read
IDR 11.4.0.5-5700 for CDC Replication Engine for Netezza
- NecessityException if external table mirror bulk apply is used and update before image is missing a column value
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
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-5700 for CDC Replication Engine for Sybase
- 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-5700 for CDC Replication Engine for Teradata
- 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
Enhancements in IDR 11.4.0.5-5699
IDR 11.4.0.5-5699 for CDC Replication Engine for MariaDB source
- Adding partition table support for MySQL/MariaDB
IDR 11.4.0.5-5699 for CDC Replication Engine for MySQL source
- Adding partition table support for MySQL/MariaDB
APARs fixed in IDR 11.4.0.5-5699
IDR 11.4.0.5-5699 for CDC Replication Engine for PostgreSQL
- JR65351 INCORRECT REPLICATION OF FRACTIONAL SECONDS DURING REFRESH IN POSTGRESQL FOR TIMESTAMP WITH TIME ZONE TYPE
Known Issues fixed in IDR 11.4.0.5-5699
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
IDR 11.4.0.5-5699 for CDC Replication Engine for BigQuery
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Datastage
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Db2 LUW
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Db2 for z/OS remote source
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Flexrep
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Informix
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for MariaDB source
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for MySQL source
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Oracle
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Oracle Trigger
- Fix incorrect product version shown in Windows program manager
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-5699 for CDC Replication Engine for PostgreSQL
- Fix incorrect product version shown in Windows program manager
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-5699 for CDC Replication Engine for Sybase
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5699 for CDC Replication Engine for Teradata
- Fix incorrect product version shown in Windows program manager
IDR 11.4.0.5-5697
Known Issues fixed in IDR 11.4.0.5-5697
IDR 11.4.0.5-5697 for Db2 for z/OS remote source
- DT243982 CDC for Db2 for z/OS remote source leaks 100 KB of ECSA memory each time IFI terminate fails. Regression was introduced in build 5694.
IDR 11.4.0.5-5696
Enhancements in IDR 11.4.0.5-5696
IDR 11.4.0.5-5696 for BigQuery
- IDR now supports BigQuery as a target
IDR 11.4.0.5-5696 for all LUW engines
- Updated JVM to 8.0.8.11, java version "1.8.0_381"
APARs in IDR 11.4.0.5-5696
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
IDR 11.4.0.5-5696 for Db2 LUW
- 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.5-5696 for Db2 for z/OS remote source
- 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.5-5696 for Informix
- 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.5-5696 for MariaDB source
- 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.5-5696 for MySQL source
- 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.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
IDR 11.4.0.5-5696 for Oracle Trigger
- 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.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.5-5696 for PostgreSQL
- 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.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.5-5696 for Sybase
- 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
IDR 11.4.0.4-5694 for Flexrep
- Added support for key pair authentication to CDC Replication Engine for FlexRep
IDR 11.4.0.4-5694 for Kafka
- Enabling JSON Records in a format excluding Data Types on Nullable columns
IDR 11.4.0.4-5694 for all LUW engines
- Updated JVM to 8.0.8.6, java version "1.8.0_371" (build 8.0.8.6 - pxz6480sr8fp6ifix-20230817_01(SR8 FP6+IJ47696))
APARs in IDR 11.4.0.4-5694
IDR 11.4.0.4-5694 for Kafka
- JR65317 CDC NOT REPORTING ERROR WHEN COMMITSTREAM TOPIC NOT ACCESSIBLE
IDR 11.4.0.4-5694 for MariaDB source
- JR65324 DMSHOWLOGDEPENDENCY COMMAND FAILS WITH NUMERIC OVERFLOW FOR HUGE BINLOG FILES
IDR 11.4.0.4-5694 for MySQL source
- JR65324 DMSHOWLOGDEPENDENCY COMMAND FAILS WITH NUMERIC OVERFLOW FOR HUGE BINLOG FILES
Bug fixes in IDR 11.4.0.4-5694
IDR 11.4.0.4-5694 for Db2 for z/OS remote source
- Replication occasionally fails with IFI error E60865 after upgrading to build 5679 or newer
IDR 11.4.0.4-5694 for MySQL source
- dmshowlogdependency command fails with 'Numeric Overflow' if a huge binlog file is found by "Show binary logs" query.
IDR 11.4.0.4-5694 for Oracle
- Oracle fails with NeccessityException "Unexpected history action transition ALTER_COLUMN to ADD_COLUMN"
IDR 11.4.0.4-5693
APARs in IDR 11.4.0.4-5693
IDR 11.4.0.4-5693 for MariaDB source
- JR65322 CDC FAILS WITH "COM.DATAMIRROR.TS.ASSERTION.NECESSITYEXCEPTION. THE ERROR VALUE IS "UNEXPECTED OPCODE X"
IDR 11.4.0.4-5693 for MySQL source
- JR65322 CDC FAILS WITH "COM.DATAMIRROR.TS.ASSERTION.NECESSITYEXCEPTION. THE ERROR VALUE IS "UNEXPECTED OPCODE X"
IDR 11.4.0.4-5686
Enhancements in IDR 11.4.0.4-5686
IDR 11.4.0.4-5686 for Db2 LUW
- 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
IDR 11.4.0.4-5686 for Db2 for z/OS remote source
- Added property to indicate the time difference between real time and log timestamp time
- 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
IDR 11.4.0.4-5686 for Informix
- 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
IDR 11.4.0.4-5686 for all LUW engines
- Updated JVM to 8.0.8.6, java version "1.8.0_371"
IDR 11.4.0.4-5686 for MariaDB source
- 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
IDR 11.4.0.4-5686 for MySQL source
- 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
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
IDR 11.4.0.4-5686 for Oracle Trigger
- 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
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
IDR 11.4.0.4-5686 for PostgreSQL
- 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
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
IDR 11.4.0.4-5686 for Sybase
- 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
APARs in IDR 11.4.0.4-5686
IDR 11.4.0.4-5686 for Oracle
- JR65293 NUMERIC OVERFLOW ERROR WHEN GETTING METADATA FOR TABLE IN REDO/XSTREAM ENGINE
IDR 11.4.0.4-5686 for Oracle - XStream
- JR65293 NUMERIC OVERFLOW ERROR WHEN GETTING METADATA FOR TABLE IN REDO/XSTREAM ENGINE
Bug fixes in IDR 11.4.0.4-5686
IDR 11.4.0.4-5686 for Db2 LUW
- Parallel refresh can hang if normal stop request or uncaught exception occurs at the beginning of the refresh
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
IDR 11.4.0.4-5684
Enhancements in IDR 11.4.0.4-5684
IDR 11.4.0.4-5684 for Db2 for z/OS remote source
- Added support for &TIMSTAMP to return per-DML operation timestamps with microsecond precision
IDR 11.4.0.4-5684 for Kafka
- Added KcopSingleRowFlatAvroAuditIntegrated supporting flat avro format.
- Temporarily disabled auto partitioning. Setting PARTITION_AUTO or PARTITION_TOPIC_topic_name in kcop.properties returns an error.
IDR 11.4.0.4-5684 for Oracle
- Added DDL Resiliency handling for Oracle Redo
APARs in IDR 11.4.0.4-5684
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
IDR 11.4.0.4-5684 for Oracle Trigger
- JR65291 DUPLICATE KEY ERROR AFTER REFRESH USING FAST LOAD WITH CURSOR STABILITY ISOLATION LEVEL FROM DB2 Z/OS SOURCE TO ORACLE TARGET
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)|
Known Issues fixed in IDR 11.4.0.4-5684
IDR 11.4.0.4-5684 for MariaDB source
- DT216021 IDR for MySql and MariaDB now supports reading large bin log file greater than 4.2 GB
IDR 11.4.0.4-5684 for MySQL source
- DT216021 IDR for MySql and MariaDB now supports reading large bin log file greater than 4.2 GB
Bug fixes in IDR 11.4.0.4-5684
IDR 11.4.0.4-5684 for Db2 for z/OS remote source
- CDC Db2 z/OS remote source stored procedure has high MIPS consumption when at head-of-log with high out-of-scope activity
- Fixed log reader to prevent Db2 abend 004E with reason code 00C90101 in CSECT DSNIDLGR.
IDR 11.4.0.4-5684 for Kafka
- Improved communication between stages of the Kafka Target Engine to reduce latency in low-volume topics amongst high-volume workloads when providing records to the underlying Kafka producers
- Following an upgrade to 11.4.0.4-5672 through 5680, mirroring for a subscription using a custom KCOP ends on error "An error is thrown by the Kafka user exit KCOP. Please check the KCOP. Error: java.lang.Error: Unresolved compilation problem: | The method createThreadSpecificContext(T, String) in the type AbstractKcop is not applicable for the arguments (AvroAuditKcopSpecificContext)"
IDR 11.4.0.4-5684 for PostgreSQL
- IDR FAILS WITH SQL EXCEPTION WHEN REPLICATING NULL DATA TO JSON AND JSONB COLUMNS
IDR 11.4.0.4-5676
Enhancements in IDR 11.4.0.4-5676
IDR 11.4.0.4-5676 for Kafka
- Improved the commit frequency in certain higher and lower volume workload scenarios
IDR 11.4.0.4-5676 for all LUW engines
- Added ParallelizeByTableNetEffect and ParallelizeByTableNetEffectConvertUpdates fast apply algorithms
IDR 11.4.0.4-5676 for MariaDB source
- Add support for JSON data types
IDR 11.4.0.4-5676 for MySQL source
- Add support for JSON data types
IDR 11.4.0.4-5676 for PostgreSQL
- IDR now supports BIT and BIT VARYING datatypes
IDR 11.4.0.4-5676 for Microsoft SQL Server
- IDR now supports Microsoft SQL Server 2022. AlwaysOn support is not yet available.
APARs in IDR 11.4.0.4-5676
IDR 11.4.0.4-5676 for Datastage
- JR65271 DMSET COMMAND FAILS FOR IIDR DATASTAGE ENGINE
Known Issues fixed in IDR 11.4.0.4-5676
IDR 11.4.0.4-5676 for MariaDB source
- DT214653 IDR for MySql and MariaDB can process bin log file greater than 2 GB and position greater than MAX INT value.
IDR 11.4.0.4-5676 for MySQL source
- DT214653 IDR for MySql and MariaDB can process bin log file greater than 2 GB and position greater than MAX INT value.
Bug fixes in IDR 11.4.0.4-5676
IDR 11.4.0.4-5676 for Kafka
- Ensured mirror_commit_after_max_seconds is being honoured in all scenarios for the CDC for Kafka target
IDR 11.4.0.4-5676 for MariaDB source
- For MariaDB source, transaction is not replicated to target if last DML in transaction is for non-inscope table.
IDR 11.4.0.4-5676 for MySQL source
- MySQL:Fix dmshowlogdependency to work when database is remote.
IDR 11.4.0.4-5674
Enhancements in IDR 11.4.0.4-5674
IDR 11.4.0.4-5674 for all LUW engines
- Updated JVMs to 8.0.8.0
IDR 11.4.0.4-5674 for Sybase
- CDC Replication Engine for Sybase databases is now available in 11.4.0.4
APARs in IDR 11.4.0.4-5674
IDR 11.4.0.4-5674 for all LUW engines
- 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
IDR 11.4.0.4-5672 for Db2 for z/OS remote source
- Added DDL Awareness for Alter Table Rename Column
IDR 11.4.0.4-5672 for all LUW engines
- New derived expression %ORDERTAB(), to track per table record sequence number, is now supported on target agent.
- Updated JVMs to 8.0.7.20
IDR 11.4.0.4-5672 for Oracle
- Introduced new undocumented parameter oracle_include_partition_id_list_file_name to replicate only listed partitions.
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
APARs in IDR 11.4.0.4-5672
IDR 11.4.0.4-5672 for Db2 LUW
- JR65248 LOG READER API RETURNS A DECOMPRESSION ERROR AND LOG READER STOPS
IDR 11.4.0.4-5672 for Db2 for z/OS remote source
- JR65241 CDC FOR DB2 FOR Z/OS REMOTE SOURCE COULD HIT ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN QUERYING GRAPHIC COLUMN TYPE
IDR 11.4.0.4-5672 for Oracle
- JR65236 CDC ORACLE CAN RETURN FOLLOWING ERROR WHEN USING KERBEROS AUTHENTICATION: [CDC][ORACLE JDBC DRIVER]NULL
IDR 11.4.0.4-5672 for Oracle Trigger
- JR65236 CDC ORACLE CAN RETURN FOLLOWING ERROR WHEN USING KERBEROS AUTHENTICATION: [CDC][ORACLE JDBC DRIVER]NULL
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
IDR 11.4.0.4-5672 for all LUW engines
- In some low volume workloads latency can be 1-5 seconds more than it should be
Other changes in IDR 11.4.0.4-5672
IDR 11.4.0.4-5672 for Oracle
- Improve retry mechanism for Oracle redo manual log shipping configuration
IDR 11.4.0.4-5670
Enhancements in IDR 11.4.0.4-5670
IDR 11.4.0.4-5670 for all LUW engines
- Prevent JDBC refresh from failing with duplicate key exceptions during standard apply
APARs in IDR 11.4.0.4-5670
IDR 11.4.0.4-5670 for Db2 LUW
- JR65237 STRUCTURE OF TABLE HAS CHANGED EVENT RAISED EVEN THOUGH NO DDL OCCURRED IF THE TABLE HAS A FOR BIT DATA COLUMN AND TABLE DEFINITION IS OLD
- JR65238 PARSING ERROR DUE TO "TABLE DEFINITION MAY HAVE CHANGED" EVENT 9506 RAISED EVEN THOUGH NO DDL HAS OCCURRED IF THE TABLE HAS A GRAPHIC COLUMN AND TABLE DEFINITION IS OLD
IDR 11.4.0.4-5670 for all LUW engines
- 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-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.
IDR 11.4.0.4-5670 for Oracle - XStream
- JR65239 CDC FOR ORACLE XSTREAM CAN'T HANDLE INVISIBLE COLUMN
IDR 11.4.0.4-5666
Enhancements in IDR 11.4.0.4-5666
IDR 11.4.0.4-5666 for Db2 LUW
- Db2 11.5.8 is now supported
IDR 11.4.0.4-5666 for Flexrep
- Added support for PostgreSQL 14
IDR 11.4.0.4-5666 for Kafka
- Distributed workload to producers move evenly and removed a possibility for not advancing bookmark when the topics mapped to a producer have infrequent changes and the source engine is CDC for z/OS native engine.
IDR 11.4.0.4-5666 for all LUW engines
- 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).
IDR 11.4.0.4-5666 for Netezza
- Netezza Performance Server v11.2.1 is now supported
IDR 11.4.0.4-5666 for PostgreSQL
- Added support for PostgreSQL 14
APARs in IDR 11.4.0.4-5666
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
Known Issues fixed in IDR 11.4.0.4-5666
IDR 11.4.0.4-5666 for MariaDB source
- DT179238 IDR FOR MARIADB DMSHOWLOGDEPENDENCY COMMAND FAILS WITH "Read agent message error"
Bug fixes in IDR 11.4.0.4-5666
IDR 11.4.0.4-5666 for Db2 for z/OS remote source
- Db2z Log Reader failing with NecessityException when processing a DDL log record
- NecessityException possible after adding a comment to a column or updating statistics
IDR 11.4.0.4-5666 for all LUW engines
- 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
IDR 11.4.0.4-5661 for Db2 LUW
- 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
IDR 11.4.0.4-5661 for Db2 for z/OS remote source
- Db2zv13 is now supported
IDR 11.4.0.4-5661 for Kafka
- Kafka client libraries are now upgraded to version 3.1.0.
IDR 11.4.0.4-5661 for all LUW engines
- JDBC batching is now allowed if target table before-operation user exits exist
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
APARs in IDR 11.4.0.4-5661
IDR 11.4.0.4-5661 for Db2 LUW
- JR65193 TABLES WITH EXTENDED ROW DATA FAIL WITH AN NPE WHEN LOB DATA IS STORED IN A SEPARATE TABLESPACE
IDR 11.4.0.4-5661 for MariaDB source
- JR65202 IDR FOR MYSQL/MARIADB WOULD FAIL WITH UNKNOWN BINARY LOG EVENT TYPE WHEN READING THE FILE HEADER INFO
IDR 11.4.0.4-5661 for MySQL source
- JR65202 IDR FOR MYSQL/MARIADB WOULD FAIL WITH UNKNOWN BINARY LOG EVENT TYPE WHEN READING THE FILE HEADER INFO
IDR 11.4.0.4-5661 for Oracle
- JR64532 FOR TRUNCATE OPERATIONS, &TIMSTAMP VALUE NOW CORRECTLY REPLICATES RECORD MODIFICATION TIME, INSTEAD OF CURRENT TIME.
Known Issues fixed in IDR 11.4.0.4-5661
IDR 11.4.0.4-5661 for MariaDB source
- DT174194 IDR FOR MARIADB, CONSUMES HIGH CPU WHILE IDLE.
Bug fixes in IDR 11.4.0.4-5661
IDR 11.4.0.4-5661 for Informix
- NPE when see an update-before log record with no subsequent update-after log record
IDR 11.4.0.4-5660
Enhancements in IDR 11.4.0.4-5660
IDR 11.4.0.4-5660 for Db2 LUW
- IDR now supports DDL resiliency by handling Db2 DDL ADD COLUMN, ALTER COLUMN, DROP COLUMN automatically
IDR 11.4.0.4-5660 for Kafka
- Enhanced commit stream consistency and removed a possibility for missing commit stream entries when encountering cluster errors on commit stream
- CDC for kafka target now supports property tcc_send_progress_stream_messages_synchronously which takes effect when kafka_bookmark_storage_type=COMMITSTREAMTOPIC and bypass_commitstream_apply_operation=false
APARs in IDR 11.4.0.4-5660
IDR 11.4.0.4-5660 for MySQL source
- JR65190 CDC ENCOUNTERED AN "UNKNOWN BINARY LOG EVENT" WHILE READING IGNORABLE BINARY LOG EVENT
- JR65185 IDR FOR MYSQL CONSUMES HIGH CPU WHILE IDLE.
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.
IDR 11.4.0.4-5659
Enhancements in IDR 11.4.0.4-5659
IDR 11.4.0.4-5659 for all LUW engines
- 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
IDR 11.4.0.4-5659 for Db2 LUW
- JR65163 MIRROR BULK APPLY CAN FAIL WITH A CLOSEEXCEPTION IF ATTEMPT DELETE ON EMPTY TABLE AND TIMING CIRCUMSTANCES ARE UNFORTUNATE
IDR 11.4.0.4-5659 for Db2 for z/OS remote source
- JR65167 DB2Z SCHEMA NAMES CAN HAVE TRAILING SPACES WHICH CAN CAUSE ADDING A TABLE MAPPING TO FAIL
- JR65173 APAR JR65173 DOUBLE-BYTE CHARACTERS STORED IN GRAPHIC TYPE COLUMNS WITH CHARACTER SET X-IBM300 ARE NOT MIRRORED CORRECTLY
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
IDR 11.4.0.4-5656
Enhancements in IDR 11.4.0.4-5656
IDR 11.4.0.4-5656 for Kafka
- Added additional internal validation of commitstream consistency when kafka_bookmark_storage_type=COMMITSTREAMTOPIC
- MODIFY FIELD SCHEMA HAS BEEN ADDED AS A NEW FEATURE FOR THE SCHEMA MODIFICATION LANGUAGE
IDR 11.4.0.4-5656 for all LUW engines
- 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
IDR 11.4.0.4-5656 for all LUW engines
- 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-5656 for MySQL source
- JR65146 IIDR CONTINUOUSLY LOGS EVENT MESSAGES DUE TO INCORRECT REALLOCATION OF BUFFER CAPACITY.
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
Bug fixes in IDR 11.4.0.4-5656
IDR 11.4.0.4-5656 for MySQL source
- IIDR continuously logs event messages due to incorrect reallocation of buffer capacity.
IDR 11.4.0.4-5652
Enhancements in IDR 11.4.0.4-5652
IDR 11.4.0.4-5652 for all LUW engines
- 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
IDR 11.4.0.4-5652 for Db2 LUW
- JR65132 MBA FAILS WITH "TEXT FIELD TOO LONG FOR COLUMN" ERR WITH CODEUNITS32 TARGET COL WITH MULTIBYTE CHARS
IDR 11.4.0.4-5652 for Kafka
- JR65094 KAFKA SUBSCRIPTION USING KCOP FAILS WITH NPE AFTER UPGRADING TO RELEASE 11.4.0.4-5644
IDR 11.4.0.4-5652 for all LUW engines
- JR65123 TRUNCATION WARNING ISSUED EVEN THOUGH THERE IS NO NON-SPACE DATA TO BE TRUNCATED
IDR 11.4.0.4-5652 for MySQL source
- JR65079 IIDR HANGS DURING HOL CONDITION AND INSTANCE TRACES ARE FLOODED WITH EVENT MESSAGES
IDR 11.4.0.4-5644
Enhancements in IDR 11.4.0.4-5644
IDR 11.4.0.4-5644 for Db2 for z/OS remote source
- IDR now supports up to 8000 tables.
- IDR now uses fewer WLM address spaces.
- IDR now detects when the stored procedure is called from the wrong LPAR.
IDR 11.4.0.4-5644 for Kafka
- Modify the value schema of producer record through MODIFY_SCHEMA_*, MODIFY_FIELD_*, "before.image.prefix", and "after.image.prefix" in the KCOP properties for all KCOPs.
- Added support for modifying Avro schemas and fields in Kafka custom operation processors (KCOPs) by adding Schema Modification Language (SML) to the parameter file
APARs in IDR 11.4.0.4-5644
IDR 11.4.0.4-5644 for Db2 LUW
- JR64910 EXTENDED ROW VARBINARY DATA CAUSES PARSER ERROR
- JR65085 NPE WHEN PERFORMING A CDC METADATA HISTORY PROGRESS CHECKPOINT WITH DPF SOURCE IF TIMING CIRCUMSTANCES ARE UNFORTUNATE
IDR 11.4.0.4-5644 for Db2 for z/OS remote source
- JR65081 DB2Z REMOTE ISSUES EVENT 9827 FOR EXISTING INSTANCES WHEN PROCESSING DDL IF DB2Z IS UPGRADED AND SYSTABLES OR SYSCOLUMNS HAVE DIFFERENT SCHEMAS
- JR65096 DMCONFIGURETS CAN FAIL WHEN GENERATING THE SCHEMA LIST IF USER USES RACF SECURITY INSTEAD OF SQL TABLE GRANTS
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
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-5644 for PostgreSQL
- JR65092 CDC POSTGRESQL AS SOURCE FAILS TO MIRROR DATA FOR PG DATABASE V9.4
- JR65100 IIDR FOR POSTGRESQL TARGET DOES NOT ALLOW ADDITIONAL TABLE MAPPINGS IN SAME SUBSCRIPTION IN ORDER WHEN DB2I IS SOURCE
Bug fixes in IDR 11.4.0.4-5644
IDR 11.4.0.4-5644 for Db2 LUW
- graphic/vargraphic columns can get column length exceeded errors
IDR 11.4.0.4-5644 for Kafka
- Fixed incorrect "doc" field in the NON-NULLABLE LOB columns in the "afterImage" field when KcopSingleRowAvroAuditIntegrated is used
IDR 11.4.0.4-5644 for PostgreSQL
- Management Console shows incompatible column encoding warning message for numeric column mapping
Other changes in IDR 11.4.0.4-5644
IDR 11.4.0.4-5644 for Db2 for z/OS remote source
- dmconfigurets can fail when generating the schema list if user uses RACF security instead of SQL Table grants
IDR 11.4.0.4-5643
Enhancements in IDR 11.4.0.4-5643
IDR 11.4.0.4-5643 for Datastage
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for Db2 LUW
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for Flexrep
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for Informix
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for all LUW engines
- Support storing replication engine database credentials in an external secret store
- Updated JVMs to 8.0.7.10
IDR 11.4.0.4-5643 for Oracle
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for Oracle Trigger
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for Oracle - XStream
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
IDR 11.4.0.4-5643 for PostgreSQL
- IIDR for PostgreSQL supports &TIMSTAMP with microsecond precision
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.
IDR 11.4.0.4-5643 for Teradata
- Fast apply modes GroupByTableNetEffect and GroupByTableNetEffectConvertUpdates are available for target engines that support fast apply.
APARs in IDR 11.4.0.4-5643
IDR 11.4.0.4-5643 for Datastage
- JR64909 USER IS UNABLE TO SAVE CHANGES TO IIDR DATASTAGE INSTANCE
IDR 11.4.0.4-5643 for Db2 LUW
- JR64939 MIRROR BULK APPLY DELETE CAN FAIL IF "KEY" COLUMNS ARE HIDDEN OR NOT MAPPED TO A SOURCE COLUMN
IDR 11.4.0.4-5643 for Oracle
IDR 11.4.0.4-5629
Enhancements in IDR 11.4.0.4-5629
IDR 11.4.0.4-5629 for Db2 for z/OS remote source
- IDR now ships with a z/OSMF portable software instance as another alternative for installing the native stored procedure
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
IDR 11.4.0.4-5629 for all LUW engines
- JR64572 NO WARNING EVENT WHEN CHARACTER DATA IS TRUNCATED
IDR 11.4.0.4-5629 for Oracle
- JR64794 LOG PARSER THROWS ARRAYINDEXOUTOFBOUNDSEXCEPTION
- JR64799 IGNORE PARTIAL LOGICAL LOG ENTRY 0501 SPLIT OPERATION
IDR 11.4.0.4-5629 for Oracle Trigger
- JR64749 CDC FOR ORACLE (TRIGGER) CAN'T CREATE INSTANCE IF TNSNAMES.ORA FILE DOESN'T EXIST UNDER $ORACLE_HOME/NETWORK/ADMIN DIRECTORY
IDR 11.4.0.4-5627
Enhancements in IDR 11.4.0.4-5627
IDR 11.4.0.4-5627 for Flexrep
- IDR can now be configured to apply data to Amazon Snowflake
IDR 11.4.0.4-5627 for all LUW engines
- Parallel Apply is now allowed with Adaptive Apply
APARs in IDR 11.4.0.4-5627
IDR 11.4.0.4-5627 for all LUW engines
- 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-5627 for PostgreSQL
- JR64754 IDR FOR POSTGRESQL ISSUES EVENT WARNING 9700 DUE TO REPORT POSITION BOOKMARK GOING BACKWARDS
Bug fixes in IDR 11.4.0.4-5627
IDR 11.4.0.4-5627 for Db2 LUW
- Fixed Mirror Bulk Apply failure with Event 9715 when binary datatype is treated incorrectly as character datatype leading to incorrect external table column definition
IDR 11.4.0.4-5625
Enhancements in IDR 11.4.0.4-5625
IDR 11.4.0.4-5625 for Db2 LUW
- IDR NOW TRACES DDL BEFORE PARSING IT AND CHECK FOR DUPLICATE RENAMED COLUMN NAMES
IDR 11.4.0.4-5625 for Db2 for z/OS remote source
- The JDBC driver has now been updated from version 5.1.4.000298 to 5.1.4.000336
IDR 11.4.0.4-5625 for all LUW engines
- 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
IDR 11.4.0.4-5625 for MariaDB source
- IDR now supports MariaDB as source
APARs in IDR 11.4.0.4-5625
IDR 11.4.0.4-5625 for Db2 LUW
- JR64571 LOG READER HANDLING FOR CREATE PARTITION DDL IS SLOW AND GENERATES EXCESSIVE TRACE LINES
IDR 11.4.0.4-5625 for Db2 for z/OS remote source
- JR64573 LOG READING IS SLOW DUE TO RETRYING TO READ LOG RECORDS WITH HARD DECOMPRESSION ERRORS
IDR 11.4.0.4-5625 for Kafka
- JR64599 TCC APPLICATION FAILS : INVALID WRITER SCHEMA VERSION 2
IDR 11.4.0.4-5625 for all LUW engines
- JR64618 DMTS64 PROCESS IS TAKING A LONGER TIME TO START
IDR 11.4.0.4-5625 for MySQL source
- JR64612 FIXED "ASSERTION.NECESSITYEXCEPTION" DURING MIRRORING FOR TIME(N) DATATYPE
- JR64635 FIXED DATA MISSING ISSUE ON TARGET WHEN LAST DML IS FOR OUT OF SCOPE TABLE IN A SOURCE TRANSACTION HAVING DML'S FOR BOTH IN SCOPE AND OUT OF SCOPE TABLES
- JR64641 FIXED "ASSERTION.NECESSITYEXCEPTION" DURING MIRRORING WHEN SELECTING TABLE FOR MAPPING FROM A DATABASE OTHER THAN THE CONFIGURED DATABASE.
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
Bug fixes in IDR 11.4.0.4-5625
IDR 11.4.0.4-5625 for Db2 for z/OS remote source
- Decompression error retry can indefinitely delay commit of log reader connection and release of database locks
IDR 11.4.0.4-5625 for all LUW engines
- 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
IDR 11.4.0.4-5622 for all LUW engines
- 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-5622 for PostgreSQL
- IDR NOW SUPPORTS REPLICATION FROM POSTGRESQL DB WITH SPECIAL CHARACTERS IN DATABASE NAME
APARs in IDR 11.4.0.4-5622
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
IDR 11.4.0.4-5622 for PostgreSQL
- JR64560 IDR FAILS WITH EXCEPTION RETRIEVING THE TABLE STRUCTURE IF TABLE OID GOES OUT OF RANGE OF INTEGER
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
Bug fixes in IDR 11.4.0.4-5622
IDR 11.4.0.4-5622 for Kafka
- Addressed an issue causing a subscription with z/OS source and Kafka target to restart from an earlier position after a table mapping is refreshed when the kafka_bookmark_storage_type datastore parameter is set to COMMITSTREAMTOPIC
IDR 11.4.0.4-5618
APARs in IDR 11.4.0.4-5618
IDR 11.4.0.4-5618 for all LUW engines
- 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-5617
Enhancements in IDR 11.4.0.4-5617
IDR 11.4.0.4-5617 for Db2 for z/OS remote source
- mirror_on_ddl_operation property now supports per-subscription-per-table, per-subscription, and per-table settings via the dmset utility
- &TIMSTAMP Journal Control Field now supports microseconds precision
IDR 11.4.0.4-5617 for Kafka
- Added SourceId as Kafka header. To include it in a kcop configuration use "headers.include.sourceid=true".
- You can add a KCOP option to change the audit JCF field name from its default name "A_
" to any other Avro compliant name.
IDR 11.4.0.4-5617 for PostgreSQL
- IDR now supports replicating from partitioned tables
- IDR now supports PostgreSQL version 12 and 13 as source and target
IDR 11.4.0.4-5616
Enhancements in IDR 11.4.0.4-5616
IDR 11.4.0.4-5616 for Kafka
- Third party Kafka dependencies that rely on SLF4J for logging are now binding to Java Util Logging (JUL) provider instead of Log4J logging provider
IDR 11.4.0.4-5616 for all LUW engines
- 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
Enhancements in IDR 11.4.0.4-5611
IDR 11.4.0.4-5611 for Db2 for z/OS remote source
- IDR now supports retry when a Db2z log reader decompression error occurs, similar to CDC for Db2 for z/OS Native Source
IDR 11.4.0.4-5611 for Kafka
- Lessen the impact of high Kafka cluster response time on replication performance when there are fewer writers than source tables
APARs in IDR 11.4.0.4-5611
IDR 11.4.0.4-5611 for all LUW engines
- JR64335 OUTOFMEMORY OCCURS WHEN TLS ENCRYPTION IS ENABLED AND MANY AGENT CONNECTIONS ARE MADE TO THE INSTANCE
IDR 11.4.0.4-5611 for PostgreSQL
- JR64328 INCLUDE TARGET SPECIFIC COMMAND LINE OPTIONS IN POSTGRESQL ENGINE
Bug fixes in IDR 11.4.0.4-5611
IDR 11.4.0.4-5611 for Kafka
- Addressed the java.lang.ClassNotFoundException: com.github.luben.zstd.ZstdInputStream thrown after the compression.type=zstd property is set in the kafkaproducer.properties file
IDR 11.4.0.4-5609
Enhancements in IDR 11.4.0.4-5609
IDR 11.4.0.4-5609 for Db2 LUW
- Truncate is now supported for parallel Mirror Bulk Apply when commitment control is off
IDR 11.4.0.4-5609 for Db2 for z/OS remote source
- Shared Scrape is now enabled by default for Db2 z/OS Remote
IDR 11.4.0.4-5609 for Flexrep
- Add support for system parameter mirror_update_exclude_unchanged_primary_index_columns to exclude primary index key columns from the update set clause if they are not changed
IDR 11.4.0.4-5609 for Informix
- CDC Replication Engine for Informix is now available in 11.4.0.4
IDR 11.4.0.4-5609 for Kafka
- You can now specify a custom classpath for KCOPs by creating and populating the CDC_Kafka_instance_directory/conf/user-classloader.cp configuration file
- You can now specify a custom Avro serializer for all Avro-compatible integrated KCOPs using the serializer.class property
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
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.
APARs in IDR 11.4.0.4-5609
IDR 11.4.0.4-5609 for Db2 for z/OS remote source
- JR64226 DATA PARSING ERROR CAN OCCUR ON THE TARGET IMMEDIATELY AFTER MIRRORING STARTS IF DDL RESILIENCY IS ENABLED
IDR 11.4.0.4-5609 for Kafka
- JR63828 LOCK TIMEOUT ON TS_BOOKMARK TABLE WHEN TARGET IS KAFKA AND METADATA IS BEING UPDATED AND SYSTEM IS BUSY
IDR 11.4.0.4-5609 for MySQL source
- JR64080 CHC9696E DATA PROTOCOL API "DPGETFIELD" REQUEST HAS FAILED ERROR OCCURS DURING STARTING SUBSCRIPTION WHEN TARGET IS CDC DB2 Z/OS
IDR 11.4.0.4-5609 for Oracle
- JR64221 CDC ABORT WHEN INCOMPLETE MULTI-BLOCK ENTRYS IS DETECTED
IDR 11.4.0.4-5607
Enhancements in IDR 11.4.0.4-5607
IDR 11.4.0.4-5607 for Db2 LUW
- IDR now maintains the order of operations for a particular primary key when using Live Audit with mirror bulk apply
IDR 11.4.0.4-5607 for Flexrep
- IDR now supports EnterpriseDB version 12 and 13 as target
IDR 11.4.0.4-5607 for PostgreSQL
- IDR for PostgreSql now supported as target engine
APARs in IDR 11.4.0.4-5607
IDR 11.4.0.4-5607 for Kafka
- JR64176 USER-SET JOURNAL CONTROL FIELDS IN AUDIT KCOPS COME OUT NON-NULLABLE, BUT SHOULD BE NULLABLE
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
IDR 11.4.0.4-5607 for all LUW engines
- 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-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
IDR 11.4.0.4-5603
Enhancements in IDR 11.4.0.4-5603
IDR 11.4.0.4-5603 for Db2 for z/OS remote source
- IDR now supports DDL resiliency by handling DDL ADD COLUMN, ALTER COLUMN, DROP COLUMN automatically
IDR 11.4.0.4-5603 for Kafka
- KcopJsonFormatIntegrated users can now override the default topic suffix "-json".
- Audit KCOPs no longer require auditing journal control fields
IDR 11.4.0.4-5603 for Oracle - XStream
- IDR now supports real-time downstream capture and archived-log downstream capture.
IDR 11.4.0.4-5603 for Teradata
- IDR now supports Teradata 17.0 and 17.1 as target
APARs in IDR 11.4.0.4-5603
IDR 11.4.0.4-5603 for Kafka
- JR63569 REFRESHING SUBSCRIPTION WITH SINGLE ROW AVRO KCOP WRITES INVALID VALUES FOR AUDIT FIELDS
- JR64072 NULL ENTTYP ON UPDATE IN JSON SINGLE ROW AUDIT KCOP
IDR 11.4.0.4-5603 for all LUW engines
- JR64071 IDR CDC FAILS WITH STATEMENT CLOSED ERROR WHILE RUNNING ADDITIONAL SQL STATEMENTS DURING REFRESH.
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
IDR 11.4.0.4-5603 for PostgreSQL
- JR64079 IDR CAN NOW REPLICATE TABLES WITH CASE-SENSITIVE NAMES
Bug fixes in IDR 11.4.0.4-5603
IDR 11.4.0.4-5603 for all LUW engines
- Addressed an issue causing an OOM error if there are large number of trace files
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.
IDR 11.4.0.4-5602
Enhancements in IDR 11.4.0.4-5602
IDR 11.4.0.4-5602 for Kafka
- The CommitStreamConsole output now includes a Transactionally Consistent Consumer (TCC) bookmark
- IDR for Kafka now uses exactly-once semantics when writing to a commit stream in order to prevent the "Progress Stream Fragments are not in sequentially ascending order" error in the Transactionally Consistent Consumer (TCC)
- The HEADER_COLUMNS_*, headers.include.schema, headers.include.table.name, headers.include.table.schema, header.prefix and header.jcfs properties can now be used to add headers to a Kafka producer record with all integrated KCOPs
- Replicating data to Kafka for consumption by the Transactionally Consistent Consumer (TCC) now requires the Kafka version 0.11 or higher
- An upgrade of the Transactionally Consistent Consumer (TCC) library is required due to a commit stream record structure change
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
APARs in IDR 11.4.0.4-5602
IDR 11.4.0.4-5602 for Kafka
- JR63770 LESSEN THE IMPACT OF HIGH LATENCY CLUSTERS WHEN THERE ARE FEWER PRODUCERS THAN SOURCE TABLES
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
Bug fixes in IDR 11.4.0.4-5602
IDR 11.4.0.4-5602 for Kafka
- Subscriptions no longer fail with the "Error deserializing key/value for partition *-commitstream" error after an upgrade from the version prior to 11.4.0.2-5503
- The getLibrary() method of the JournalHeaderIF interface now correctly returns a table schema when called from a KCOP or a user exit
IDR 11.4.0.4-5599
Enhancements in IDR 11.4.0.4-5599
IDR 11.4.0.4-5599 for Kafka
- The default Non-KCOP behaviour and all KCOPs leveraging the Kafka-Avro-Serializer are now using a Kafka-Avro-Serializer at version 5.3.1
IDR 11.4.0.4-5599 for all LUW engines
- Updated the Java Virtual Machine to IBM 8.0.6.30
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
IDR 11.4.0.4-5599 for Oracle Trigger
- Add Kerberos authentication support for CDC for Oracle replication engines
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.
APARs in IDR 11.4.0.4-5599
IDR 11.4.0.4-5599 for Datastage
- JR63800 UNABLE TO CREATE INSTANCE IN COMMAND LINE
IDR 11.4.0.4-5599 for Kafka
- JR63800 UNABLE TO CREATE INSTANCE IN COMMAND LINE
IDR 11.4.0.4-5599 for all LUW engines
- 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
IDR 11.4.0.4-5599 for all LUW engines
- 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
APARs in IDR 11.4.0.3-5596
IDR 11.4.0.3-5596 for Db2 LUW
- JR63644 DB2 INSTANCE CREATION FAILS WHEN FASTLOAD OPTION IS NOT SELECTED FOR REFRESH
IDR 11.4.0.3-5596 for Kafka
- JR63445 HEADERS OF BINARY AVRO COLUMNS IN THE SINGLE ROW AVRO AUDIT KCOP DO NOT CONTAIN BYTE CONTENT
IDR 11.4.0.3-5596 for MySQL source
- JR63704 CDC IS QUERYING MYSQL DATABASE FOR LOB DATA RATHER THAN READING FROM LOG
- JR63528 DMIMPORTCONFIGUARATION DOES NOT ALLOW TO IMPORT INSTANCE CONFIGURATION FOR MYSQL COMMUNITY EDITION
IDR 11.4.0.3-5596 for Oracle
- JR63609 CDC FOR ORACLE (REDO) CONNECTION LEAK CAN OCCUR DURING METADATA MIGRATION
IDR 11.4.0.3-5596 for PostgreSQL
- JR63722 IIDR FAILS WHEN SAME SOURCE TABLE IS MAPPED IN MORE THAN ONE SUBSCRIPTION
- JR63733 IIDR FAILS WHEN PARSING TIMESTAMP WITH TIMEZONE COLUMN DATA WITH NO FRACTIONAL SECONDS
IDR 11.4.0.3-5596 for Db2 for z/OS remote source
- JR63624 IDR CDC FOR DB2 FOR Z/OS REMOTE SOURCE LOG PARSER CAN STOP WITH EXCEPTION "THE ERROR VALUE IS NNNN:NNNN:NNNN"
Bug fixes in IDR 11.4.0.3-5596
IDR 11.4.0.3-5596 for all LUW engines
- Fixed NecessityException in ChangeLogBlock on instance start up
IDR 11.4.0.3-5594
Enhancements in IDR 11.4.0.3-5594
IDR 11.4.0.3-5594 for Oracle
- IDR for Oracle now automatically refresh Oracle database system table information on startup
IDR 11.4.0.3-5594 for PostgreSQL
- IDR now supports JSONB datatype
APARs in IDR 11.4.0.3-5594
IDR 11.4.0.3-5594 for Db2 LUW
- JR63140 IDR DB2WH CAN FAIL WITH "EXECUTE BULK APPLY STATEMENT THREAD HAS NOT EXECUTED THE STATEMENT WE SENT IT AFTER 60000 MILLISECONDS"
IDR 11.4.0.3-5594 for all LUW engines
- 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-5594 for Oracle
- JR63100 CDC IS DETECTING EXTRA ENTRY FOR QUICK MULTI DELETE
- JR63523 UNEXPECTED HISTORY ACTION TRANSITION TRUNCATE_PARTITION TO ADD_PARTITION
IDR 11.4.0.3-5594 for PostgreSQL
- JR63532 FIXED CONNECTION ISSUE FOR QUERY THAT WAS BLOCKING POSTGRESQL VACUUM PROCESS
Bug fixes in IDR 11.4.0.3-5594
IDR 11.4.0.3-5594 for PostgreSQL
- Fixed data parse error when parsing timestamp with time zone column offset
IDR 11.4.0.3-5594 for Db2 for z/OS remote source
- Addressed an issue that used to prevent a subscription from stopping as intended for an IFI306 decompression error
IDR 11.4.0.3-5593
Enhancements in IDR 11.4.0.3-5593
IDR 11.4.0.3-5593 for PostgreSQL
- IDR now supports JSON datatype
APARs in IDR 11.4.0.3-5593
IDR 11.4.0.3-5593 for Kafka
- JR63374 SUBSCRIPTION DOES NOT SHUT DOWN WHEN THE NUMBER OF KAFKA WRITER THREADS ASSIGNED TO IT IS LESS THAN THE NUMBER OF TABLE MAPPINGS
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
IDR 11.4.0.3-5593 for Kafka
- Fixed NPE in KcopSingleRowAvroAuditHeadersIntegrated when "header.columns" is not present within the KCOP properties file.
- Addressed an issue that prevented the events 3170, 3171, 3172, 3173 from being logged when latency thresholds defined for a subscription were crossed
- Addressed an issue that caused Management Console to display latency status as Normal even when latency thresholds defined for a subscriptions were exceeded
IDR 11.4.0.3-5593 for PostgreSQL
- Product won't set replica identity of table to full if it is already set
IDR 11.4.0.3-5593 for Oracle
- IDR now processes all the logs, before declaring a sequence gap.
IDR 11.4.0.3-5590
Enhancements in IDR 11.4.0.3-5590
IDR 11.4.0.3-5590 for Kafka
- Kafka producer statistics are now collected and persisted during replication
IDR 11.4.0.3-5590 for PostgreSQL
- Improved logical replication slots handling by disabling staging store for PostgreSQL sources
- Removed redundant PostgreSQL source system parameters postgresql_update_flush_lsn_delay and postgresql_update_flush_lsn_threashold_hours
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.
APARs in IDR 11.4.0.3-5590
IDR 11.4.0.3-5590 for Db2 for z/OS remote source
- JR63237 LOG READER API RETURNS A DECOMPRESSION ERROR AND LOG READER STOPS
- JR63382 PARSING ERRORS CAN OCCUR IN CDC DB2Z REMOTE AFTER A DDL AND AFTER RE-ADDING THE TABLE DEFINITION IF SHARED SCRAPE IS USED
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
IDR 11.4.0.3-5590 for PostgreSQL
- JR63347 FIXED OUT-OF-ORDER PROGRESS MESSAGE SENT FOR POSTGRESQL SOURCE
Bug fixes in IDR 11.4.0.3-5590
IDR 11.4.0.3-5590 for Db2 LUW
- JR63346 IDR now supports Fastload Refresh for Live Audit mapping
IDR 11.4.0.3-5590 for Db2 for z/OS remote source
- Addressed an issue causing SQLNonTransientConnectionException while interacting with the Db2 database that prevented persistent subscriptions from restarting after an error when shared scrape was enabled
- Addressed an issue that caused Db2 on z/OS to ABEND with reason code 00D3003B after subscription is shut down normally with shared scrape enabled
IDR 11.4.0.3-5590 for Kafka
- Addressed an issue that prevented a subscription from shutting down if a target topic did not exist and could not be created
- Addressed an issue that prevented a subscription from stopping when a normal shutdown was followed by a shutdown immediate or abort
IDR 11.4.0.3-5590 for Oracle
- JR63346 IDR now supports Fastload Refresh for Live Audit mapping
IDR 11.4.0.3-5590 for PostgreSQL
- Fixed WAL file accumulation due to CDC replication slots
- Fixed issue of restart_lsn of replication slot not being updated
IDR 11.4.0.3-5587
Enhancements in IDR 11.4.0.3-5587
IDR 11.4.0.3-5587 for Db2 for z/OS remote source
- You can now use the JDBC driver's KeepAlive capability to stop subscriptions automatically when network problems occur between CDC agent and Db2 on z/OS
- JDBC Driver for Db2 for z/OS has been updated from 5.1.4.000288 to 5.1.4.000298
IDR 11.4.0.3-5587 for Kafka
- The new PARTITION_TOPIC_* and PARTITION_DEFAULT properties can now be used with all KCOPs that are shipped with the product
- The mirror_write_format and the mirror_[timestamp|time|date|decimal]_write_format datastore parameters can now be set per subscription
- Added the lenientTail() method to the TxConsistentConsumerBookmarkBuilder interface, which returns the bookmark of the first usable record in a commit stream
- You can now use the "-bk" option to specify a bookmark when running CommitStreamConsole
- You can now use the parameter tx_consistent_consumer_lenient_read to prevent TCC from failing when a record is missing from a data topic
APARs in IDR 11.4.0.3-5587
IDR 11.4.0.3-5587 for Oracle
- JR63222 SUBSCRIPTION FAILS WITH AN ERROR: UNEXPECTED PARSING ERROR FOR TABLE SYS.PARTLOB$
Bug fixes in IDR 11.4.0.3-5587
IDR 11.4.0.3-5587 for Db2 for z/OS remote source
- Addressed the Db2 IFI 306 ABEND with reason code 00E60863, which can occur when Db2 on z/OS ZPARM CMSTAT is set to INACTIVE, and when network problems cause connections to hang or be dropped
- Addressed an issue that caused IDR to issue rollbacks to Db2 on z/OS too frequently starting with product build 5574
IDR 11.4.0.3-5587 for Kafka
- Addressed an issue that caused a subscription to fail with a NecessityException and the "Failed to update KafkaTopicOperationSequenceRecordList" error meesage
- The TxConsistentConsumerException.tail() method now correctly returns the bookmark of the very first record replicated to Kafka
IDR 11.4.0.3-5582
Enhancements in IDR 11.4.0.3-5582
IDR 11.4.0.3-5582 for Db2 for z/OS remote source
- CDC Replication Engine for Db2 for z/OS Remote Source now handles Db2z Utility actions similar to CDC for Db2 for z/OS Native Source
IDR 11.4.0.3-5582 for Kafka
- The MAP_TABLE_*, MAP_DEFAULT and MAP_ALL properties can now be used with all KCOPs that are shipped with the product
IDR 11.4.0.3-5582 for Oracle Trigger
- IDR as source, now supports scraping Oracle databases using triggers
APARs in IDR 11.4.0.3-5582
IDR 11.4.0.3-5582 for MySQL source
- JR63116 FIXED "LOGFILENOTFOUNDEXCEPTION" WHEN ANY BINARY LOG IN THE DIRECTORY DID NOT HAVE GTID EVENT PRESENT IN THAT BINARY LOG.
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
Bug fixes in IDR 11.4.0.3-5582
IDR 11.4.0.3-5582 for Kafka
- Addressed an issue preventing a subscription from shutting down when a commit stream did not not exist, could not be auto-created and retries were enabled in the kafkaproducer.properties file
- Addressed an issue that caused a subscription to fail with the OutOfMemoryError or stall when refreshing a large table with a Kafka partitioner or a KCOP partitioner
- Addressed an issue that caused TCC to throw the NecessityException with the error "An incorrect record read from the input queue" when using the tx_consistent_consumer_max_number_of_kafka_consumers property to limit the number of Kafka consumers
IDR 11.4.0.3-5582 for Teradata
- Fixed issue which caused error "LOBs are not allowed in indexes" when BYTE or VARBYTE is used as part of index
IDR 11.4.0.3-5576
Enhancements in IDR 11.4.0.3-5576
IDR 11.4.0.3-5576 for Db2 LUW
- Add new system parameter " alter_table_data_capture_flag_allow_turn_off" to allow/disallow a CDC source engine to turn off data capture when the table is no longer mapped in any subscription
IDR 11.4.0.3-5576 for Db2 for z/OS remote source
- Add new system parameter " alter_table_data_capture_flag_allow_turn_off" to allow/disallow a CDC source engine to turn off data capture when the table is no longer mapped in any subscription
IDR 11.4.0.3-5576 for Kafka
- Management Console now displays the "Target Database" bottleneck instead of the "Target Engine" when replication is slowed down by Kafka producer send
- A log compacted topic can now be used as a Commit Stream
- JR63074 COLUMN SIZE TRUNCATED ON CDC KAFKA TARGET
IDR 11.4.0.3-5576 for all LUW engines
- The dmsupportinfo command line utility now dumps and collects configuration metadata in a text format
IDR 11.4.0.3-5576 for MySQL source
- Add new system parameter " alter_table_data_capture_flag_allow_turn_off" to allow/disallow a CDC source engine to turn off data capture when the table is no longer mapped in any subscription
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
APARs in IDR 11.4.0.3-5576
IDR 11.4.0.3-5576 for Kafka
- JR63074 COLUMN SIZE TRUNCATED ON CDC KAFKA TARGET
IDR 11.4.0.3-5576 for all LUW engines
- JR62920 EXCESSIVE DIAGNOSTIC PROBES FOR TRUNCATE OF CLOB EVENTS
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
Bug fixes in IDR 11.4.0.3-5576
IDR 11.4.0.3-5576 for all LUW engines
- 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-5574
Bug fixes in IDR 11.4.0.3-5574
IDR 11.4.0.3-5574 for Db2 for z/OS remote source
- Now IDR wont set query timeout for stored procedure call, if timeout is zero
IDR 11.4.0.3-5572
Enhancements in IDR 11.4.0.3-5572
IDR 11.4.0.3-5572 for Db2 LUW
- IDR SOMETIMES NOT DETECTING DROP AND RECREATE TABLE DDL
IDR 11.4.0.3-5572 for Db2 for z/OS remote source
- Add a time limit to the stored procedure call and fail if timeout is exceeded
IDR 11.4.0.3-5572 for all LUW engines
- 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
IDR 11.4.0.3-5572 for Db2 LUW
- JR62953 MIRROR BULK APPLY CAN FAIL APPLYING AN UPDATE IF "MINIMIZENETWORKLOAD" IS SET FOR A TABLE
IDR 11.4.0.3-5572 for all LUW engines
- JR62909 INCORRECT SAMPLE CONTENT WHEN ISSUING "DMEXPORTCONFIGURATION -?"
- JR62934 DMTS64 NOT RELEASING IX (EXCLUSIVE) LOCK ON SYSTABLES AFTER MAKING DATABASEMETADATA CALLS
IDR 11.4.0.3-5572 for MySQL source
- JR62951 IMPROVED ERROR MESSAGE WHEN PRODUCT IS FAILING WITH LOG FILE NOT FOUND EXCEPTION AFTER REFRESH
IDR 11.4.0.3-5572 for Netezza
- JR62953 MIRROR BULK APPLY CAN FAIL APPLYING AN UPDATE IF "MINIMIZENETWORKLOAD" IS SET FOR A TABLE
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
Bug fixes in IDR 11.4.0.3-5572
IDR 11.4.0.3-5572 for Kafka
- Removed possible hang and operation mis-ordering condition when multiple image builders employed. This may occur with default behaviour of the Kafka engine or a KCOP producing multiple Kafka messages per single source operation.
IDR 11.4.0.3-5572 for all LUW engines
- &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
IDR 11.4.0.3-5570 for Kafka
- Transactionally Consistent Consumer (TCC) now throws an exception after a commit stream topic is truncated during processing
- Transactionally Consistent Consumer (TCC) is now able to recreate the correct sequence of operations when idempotence is disabled and records are produced to a data topic out-of-order
- TCC API topic level include and exclude filtering now supports partition level granularity, which allows the TCC to return specific topic/partition pairs written by a given subscription.
IDR 11.4.0.3-5570 for all LUW engines
- 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
IDR 11.4.0.3-5570 for PostgreSQL
- UUID datatype is supported now
APARs in IDR 11.4.0.3-5570
IDR 11.4.0.3-5570 for Db2 LUW
- JR62800 DMSHOWLOGDEPENDENCY RETURNS INCORRECT LRI VALUE RESULTING IN NO DEPENDENT LOG FILES BEING FOUND FOR DB2 LUW 10.5.9 AND LATER.
- JR62871 REPORT PRIMARY INDEXES PROPERLY FOR CHCCLP LIST TABLE INDEXES COMMAND
IDR 11.4.0.3-5570 for all LUW engines
- 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
IDR 11.4.0.3-5570 for Oracle
- JR62613 PRIMARY KEY NOT GETTING UPDATED IN TABLE PROPERTIES
IDR 11.4.0.3-5570 for PostgreSQL
- JR62779 CDC THROWS A DATA PARSE EXCEPTION WHEN PARSING DATA FOR TABLES WITH QUOTED COLUMN NAMES
Bug fixes in IDR 11.4.0.3-5570
IDR 11.4.0.3-5570 for Kafka
- Refresh now completes successfully instead of stalling when the number of binary writers is lower than the number of topic partitions and a KCOP is used to partition records
IDR 11.4.0.3-5570 for all LUW engines
- Addressed a defect in the dmsupportinfo command line utility that caused trace files to be omitted during collection
IDR 11.4.0.3-5569
APARs in IDR 11.4.0.3-5569
IDR 11.4.0.3-5569 for Oracle
- JR62730 CDC FOR ORACLE CAN SOMETIMES APPEND EXTRA 0X00(S) TO THE EDT COLUMNS
IDR 11.4.0.3-5567
Enhancements in IDR 11.4.0.3-5567
IDR 11.4.0.3-5567 for Kafka
- Kafka libraries are now upgraded to version 2.3.1
- Event 9809 now includes the name of the affected Kafka topic
APARs in IDR 11.4.0.3-5567
IDR 11.4.0.3-5567 for Datastage
- JR62293 IDR CANNOT FIND THE CORRECT SCHEMA AFTER UPGRADING AND STARTING THE INSTANCE
IDR 11.4.0.3-5567 for Kafka
- JR62293 IDR CANNOT FIND THE CORRECT SCHEMA AFTER UPGRADING AND STARTING THE INSTANCE
IDR 11.4.0.3-5567 for all LUW engines
- JR62737 CDC ERROR 9506 OCCURS AFTER A DDL EVEN WHEN ALL DDL PROCEDURES ARE FOLLOWED
IDR 11.4.0.3-5567 for MySQL source
- JR62751 FIXED "ENCOUNTERED AN UNKNOWN MYSQL LOG EVENT TYPE" ERROR WHILE READING BINARY LOG
IDR 11.4.0.3-5567 for Oracle
- JR62646 FIXED REMOTE LOG READING ERROR: FILE NOT FOUND EXCEPTION FOR NON ASM SETUP
Bug fixes in IDR 11.4.0.3-5567
IDR 11.4.0.3-5567 for Db2 LUW
- CDC can hang when applying a Db2 Warehouse delete using Mirror Bulk Apply if the target table is empty
IDR 11.4.0.3-5567 for all LUW engines
- 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
IDR 11.4.0.3-5566 for Flexrep
- Now supports installation as target on IBM LinuxONE
IDR 11.4.0.3-5566 for all LUW engines
- Java Runtime Environment updated from IBM Java 8.0.6.0 to 8.0.6.10. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/
IDR 11.4.0.3-5566 for MySQL source
- Now supports installation as source on IBM LinuxONE
APARs in IDR 11.4.0.3-5566
IDR 11.4.0.3-5566 for Db2 LUW
- JR62549 REFRESH FAILS USING FASTLOAD WHEN SCHEMA LEVEL BACKUP FEATURE ENABLED IN DB2WAREHOUSE
- JR62477 SUBSEQUENT DML AFTER A DB2 ALTER TABLE RENAME COLUMN OPERATION IS REPLICATED STILL USES OLD COLUMN NAME
IDR 11.4.0.3-5566 for Kafka
- JR61151 JAVA.LANG.NULLPOINTEREXCEPTIONERROR WITH LOB DATA USING KAFKA.KCOPMULTIROWAVROLIVEAUDITINTEGRATED
IDR 11.4.0.3-5566 for all LUW engines
- JR62628 INDEX OUT OF BOUNDS EXCEPTION CAN OCCUR AT DBCONNECTIONMANAGER.RELEASEMETADATASESSION()
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
Bug fixes in IDR 11.4.0.3-5566
IDR 11.4.0.3-5566 for Kafka
- KCOP filter might lead to target pipeline hang when using multiple formatter threads
IDR 11.4.0.3-5566 for MySQL source
- JR62618 UPGRADE FOR COMMUNITY EDITION FAILS WITH "Connections to MySQL Community Server are not supported."
Other changes in IDR 11.4.0.3-5566
IDR 11.4.0.3-5566 for PostgreSQL
- Improve PostgreSQL flushLSN handling when PostgreSQL database is idle
- Added extra optional parameter in dmsetpostgresqlflushlsn command to specify flushLSN position
IDR 11.4.0.2-5564
APARs in IDR 11.4.0.2-5564
IDR 11.4.0.2-5564 for Oracle
- JR62378 ADDED SUPPORT TO ENABLE REMOTE ORACLE AFD
IDR 11.4.0.2-5563
Enhancements in IDR 11.4.0.2-5563
IDR 11.4.0.2-5563 for Kafka
- Added a new KCOP that allows for replication of audit journal fields and before image with messages delivered in JSON format
- Transactionally Consistent Consumer (TCC) now allows a renamed version of ts.jar to be included in CLASSPATH
- Transactionally Consistent Consumer (TCC) now provides an alternate overloaded constructor that permits passing in Kafka consumer properties as an instance of java.util.Properties
- Transactionally Consistent Consumer (TCC) now correctly sets the cause of TxConsistentConsumerException
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.
IDR 11.4.0.2-5563 for PostgreSQL
- Improved flush LSN handling of PostgreSQL logical replication slots
- Modified NUMERIC data value handling for PostgreSQL source when no precision or scale is specified
APARs in IDR 11.4.0.2-5563
IDR 11.4.0.2-5563 for Db2 LUW
- JR62469 REFRESH FAILS USING FASTLOAD WHEN TARGET TABLE CONTAINS IMPLICITLY HIDDEN RANDOM_DISTRIBUTION_KEY COLUMN
- JR62454 IDR OPERATIONS ARE NO LONGER LOST ON A TABLE PARTITIONED ON MORE THAN ONE DPF NODE
- JR62455 IDR SCRAPEDTABLECONTEXTSTORAGE ASSUMES AN INTERVAL EXISTS FOR AL L JOURNALS WHICH CAN RESULT IN AN ARRAYINDEXOUTOFBOUNDSEXCEPTION
IDR 11.4.0.2-5563 for all LUW engines
- JR62451 IDR REPLICATES SOURCE DERIVED COLUMN DATA TO INCORRECT TARGET COLUMN
Bug fixes in IDR 11.4.0.2-5563
IDR 11.4.0.2-5563 for Kafka
- Addressed a resource leak in Transactionally Consistent Consumer (TCC) caused by Kafka consumers not being closed after they are no longer needed
IDR 11.4.0.2-5563 for MySQL source
- Fixed issue with incorrect fractional seconds precision value during jdbc call when source is community edition.
- Fixed subscriptions failing with IllegalArgumentException when setting the current event length.
IDR 11.4.0.2-5560
Enhancements in IDR 11.4.0.2-5560
IDR 11.4.0.2-5560 for all LUW engines
- Instance-specific command line utilities now trace their parameters and an execution return code.
IDR 11.4.0.2-5560 for SQL Server
- IDR now supports Microsoft SQL Server 2019
APARs in IDR 11.4.0.2-5560
IDR 11.4.0.2-5560 for Db2 for z/OS remote source
- JR62160 LOG PARSER CANNOT PARSE A DML AFTER A DDL EVEN AFTER UPDATING THE TABLE DEFINITION AND REFRESHING THE TABLE
IDR 11.4.0.2-5560 for Kafka
- JR62289 UPDATE OPERATION MAY BE LOST OR APPLIED OUT-OF-ORDER WITH MULTIPLE FORMATTER THREADS
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
IDR 11.4.0.2-5560 for Db2 for z/OS remote source
- IDR now correctly maps the parameters to the error message when the table version in the log for a specific log entry is below the latest table version from the database that is caused by table structure change (DDL) applied in the past.
IDR 11.4.0.2-5560 for all LUW engines
- 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-5560 for Oracle
- dmconfigurets now correctly shows a list of innaccessible mount point overrides.
IDR 11.4.0.2-5560 for 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
IDR 11.4.0.2-5548
APARs in IDR 11.4.0.2-5548
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
Bug fixes in IDR 11.4.0.2-5548
IDR 11.4.0.2-5548 for Kafka
- Improved TCC Buffered Queue Writer Timeout Handling
IDR 11.4.0.2-5548 for MySQL source
- IDR now allows mapping tables from databases other than the one cdc instance is configured with when using MySQL Community Edition.
- IDR now allows using schema/database having special characters like (_ and %) in name.
- IDR now fixed instance creation issue for MySQL 8.0 Community Edition.
IDR 11.4.0.2-5544
Enhancements in IDR 11.4.0.2-5544
IDR 11.4.0.2-5544 for Flexrep
- IDR now supports MySQL version 8.0 as target
- IDR now supports EnterpriseDB version 10 and 11 as target
IDR 11.4.0.2-5544 for Kafka
- IDR supports configuring kafkaproducer.properties and kafkaconsumer.properties files per CDC instance
IDR 11.4.0.2-5544 for all LUW engines
- dmsupportinfo no longer collects duplicate information in the "dir.txt" support assistant file when an instance folder is inside the product installation directory.
IDR 11.4.0.2-5544 for Oracle
- IDR for Oracle now supports AFD ( ASM Filter Driver)
IDR 11.4.0.2-5544 for SQL Server
- IDR is now able to replicate duplicate updates and deletes by limiting the modification to 1 row when applying data.
APARs in IDR 11.4.0.2-5544
IDR 11.4.0.2-5544 for Kafka
- JR62030 UPGRADING CDC KAFKA RESETS KAFKAPRODUCER.PROPERTIES SETTINGS
IDR 11.4.0.2-5544 for all LUW engines
- 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.
IDR 11.4.0.2-5544 for Oracle
- JR62068 IDR FOR ORACLE FAILS WHILE CREATING INSTANCE WITH ORACLE 19.6 WITH ERROR MUNMAP_CHUNK(): INVALID POINTER AND GENERATE CORE DUMP.
- 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.
Bug fixes in IDR 11.4.0.2-5544
IDR 11.4.0.2-5544 for Db2 LUW
- Addressed 'Table was created, but history has no knowledge of its schema' error during mirroring when the replication product processes a create table DDL and no rule based table mappings had previously been created in any subscription
IDR 11.4.0.2-5544 for Db2 for z/OS remote source
- Addressed replication of corrupted data in the fractional part of TIMESTAMP(p) and TIMESTAMP(p) WITH TIME ZONE where p is 1, 3, 5, 7, 9, or 11.
IDR 11.4.0.2-5544 for Kafka
- Addressed "com.datamirror.ts.assertion.NecessityException The error value is "10,000"" when replicating the timestamp value of "9999-12-31 24:00:00.0000000000000".
- Adapted intermittent "io.confluent.kafka.schemaregistry.client.rest.exceptions.RestClientException: Register operation timed out; error code: 50002" that could be issued due schema registry connection timeout to be logged as an CDC engine event and have replication stop normally due to the error.
IDR 11.4.0.2-5544 for all LUW engines
- 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-5543
APARs in IDR 11.4.0.2-5543
IDR 11.4.0.2-5543 for Db2 for z/OS remote source
- JR62072 IDR CAUSES DB2 ON ZOS ABEND WHEN ZPARM CMTSTAT IS INACTIVE.
IDR 11.4.0.2-5528
Enhancements in IDR 11.4.0.2-5528
IDR 11.4.0.2-5528 for Db2 for z/OS remote source
- IDR now sets the APPLICATION NAME to identify IDR database connections shown in the -DISPLAY THREAD Db2 command.
IDR 11.4.0.2-5528 for all LUW engines
- 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.
IDR 11.4.0.2-5528 for MySQL source
- The JDBC driver has now been updated from version 5.1.4.000157 to 5.1.4.000223.
- IDR for MySQL now supports MySQL version 8.0 as source.
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 11.4.0.2-5528 for PostgreSQL
- dmsetpostgresqlflushlsn command line utility has been enhanced to flush lsn and release older unnecessary WAL files across all subscriptions without requiring to stop any subscription
- dmsetpostgresqlflushlsn command line utility has an improved performance
IDR 11.4.0.2-5528 for 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.
APARs in IDR 11.4.0.2-5528
IDR 11.4.0.2-5528 for Db2 LUW
- JR62021 CDC DB2 WAREHOUSE MIRROR BULK APPLY (MBA) INSERT WOULD FAIL IF THE TARGET TABLE HAS GRAPHIC OR VARGRAPHIC COLUMNS.
IDR 11.4.0.2-5528 for Db2 for z/OS remote source
- JR61947 SQLNONTRANSIENTCONNECTIONEXCEPTION IN LOG PARSER WHEN PARSING FIRST CHANGES FOR TWO TABLES SEPARATED BY MORE THAN IDTHTOIN SECS
- JR61901 INVALID SUBTYPE FOR CHARACTER DATA: UNKNOWN ON TABLE ORGINALLY CREATED IN DB2 6 WITH SYSIBM.SYSCOLUMNS.FOREIGNKEY BLANK
IDR 11.4.0.2-5528 for all LUW engines
- JR61841 ERROR REFRESHING A TABLE WITH A LONG COLUMN COMMENT: "AN UNCAUGHT EXCEPTION HAS OCCURRED"
IDR 11.4.0.2-5528 for MySQL source
- JR61831 SUPPORT SELECT TABLES FROM ANOTHER DB OTHER THAN USING WHICH CDC INSTANCE IS CREATED.
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
Bug fixes in IDR 11.4.0.2-5528
IDR 11.4.0.2-5528 for Db2 for z/OS remote source
- IDR now detects the correct Db2 12 version when ZPARM DDF_COMPATIBILITY includes IDNTFY_V12_PRIOR_VER.
IDR 11.4.0.2-5528 for all LUW engines
- 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-5528 for MySQL source
- Addressed LogFileNotFoundException at replication start up issued by the log reader after mysql database restart while log files to be replicated are still present on disk.
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 11.4.0.2-5528 for PostgreSQL
- Addressed out of memory exceptions seen in dmsetpostgresqlflushlsn command line utility
IDR 11.4.0.2-5528 for 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 11.4.0.2-5522
Enhancements in IDR 11.4.0.2-5522
IDR 11.4.0.2-5522 for Db2 LUW
- The engine now supports database alias being different from the database name
IDR 11.4.0.2-5522 for Db2 for z/OS remote source
- IDR now reports a clear error message when the user is missing the MONITOR2 system privilege.
- IDR now provides samples for granting privileges and for configuring and testing the external stored procedure.
IDR 11.4.0.2-5522 for Flexrep
- Flexrep no longer requires support for stored procedures from destination database at instance creation
- The replication engine now distributes Redshift JDBC driver from Datadirect
- IDR can now be configured to apply data to Amazon Redshift
IDR 11.4.0.2-5522 for Kafka
- The engine no longer errs with SerializationException when replicating DMSETBOOKMARK from the source
IDR 11.4.0.2-5522 for all LUW engines
- IDR issues an improved error message when dmconfigurets is run with non-Administrator privileges in Windows Server 2016
IDR 11.4.0.2-5522 for Oracle
- IDR for oracle now supports oracle ADWC/OLTP as target.
APARs in IDR 11.4.0.2-5522
IDR 11.4.0.2-5522 for all LUW engines
- 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-5522 for Oracle
- JR61828 CREATE INDEX DDL FAILS, IF IT IS ALTERED AS UNUSABLE DURING RULE-BASED REFRESH.
Bug fixes in IDR 11.4.0.2-5522
IDR 11.4.0.2-5522 for Db2 for z/OS remote source
- Resolved missing error message when failing to obtain a valid head of log position. This prevents getting "Log position 00000000000000000000 is not a valid starting position for reading the transaction log."
Other changes in IDR 11.4.0.2-5522
IDR 11.4.0.2-5522 for all LUW engines
- Java Runtime Environment updated from IBM Java 8.0.5.41 to 8.0.6.0. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/
IDR 11.4.0.2-5521
Enhancements in IDR 11.4.0.2-5521
IDR 11.4.0.2-5521 for 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
APARs in IDR 11.4.0.2-5521
IDR 11.4.0.2-5521 for Datastage
- JR61797 IIDR FOR DATASTAGE MAY ENCOUNTER A LOCK TIMEOUT RETRIEVING INTERNAL BOOKMARK INFORMATION
IDR 11.4.0.2-5521 for Db2 LUW
- JR61769 IDR FOR DB2LUW MAY FAIL ON TARGET APPLY WITH ERROR SQLCODE -805 (TOO MANY OPEN STATEMENTS) WHEN REPLICATING DECFLOAT COLUMNS THAT HAVE SPECIAL VALUES
IDR 11.4.0.2-5521 for MySQL source
- JR61490 IDR FOR MYSQL NOW SUPPORT STOP BINARY LOG EVENT.
IDR 11.4.0.2-5521 for Netezza
- JR61812 CREATING A CDC NETEZZA INSTANCE USING AN ADMIN SCHEMA RETURNS ERROR NULL POINTER EXCEPTION (NPE)
IDR 11.4.0.2-5521 for Oracle
- APAR JR61779 CDC (ORACLE REDO) CAN HAVE PARSER FAILURE WHEN ONLY REDO LOG ENTRY IS ENCRYPTED
Bug fixes in IDR 11.4.0.2-5521
IDR 11.4.0.2-5521 for Kafka
- Addressed UnresolvedUnionException when replicating a FLOAT derived column with length <= 4
- The replication engine now has enhanced support for Kafka retry properties and improved resiliency when replicating metadata to Kafka
Other changes in IDR 11.4.0.2-5521
IDR 11.4.0.2-5521 for all LUW engines
- Java Runtime Environment updated from IBM Java 8.0.5.26 to 8.0.5.41. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/
IDR 11.4.0.2-5512
Enhancements in IDR 11.4.0.2-5512
IDR 11.4.0.2-5512 for Db2 for z/OS remote source
- IDR now supports Dovetailed Co:Z SFTP server, even when Dovetailed Co:Z SFTP server is configured to transfer files in text mode by default.
- IDR now supports preconfiguration of the external stored procedure. If the external stored procedure for the current product version has already been installed correctly, then it will not be reinstalled.
- IDR now supports configuring an instance with one user that has the privileges to install the external stored procedure and then reconfiguring the instance with a different user that lacks the privileges to install the stored procedure. This allows IDR to run with the minimum privileges needed for replication, without the privileges needed for installation.
- IDR now allows manual installation of the external stored procedure.
IDR 11.4.0.2-5512 for Kafka
- IDR no longer requires a custom KCOP to connect to IBM Event Streams.
- Datastore parameters mirror_timestamp_write_format, mirror_time_write_format and mirror_date_write_format can now be set to SIMPLE to enable high-performance formatter.
IDR 11.4.0.2-5512 for all LUW engines
- 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
IDR 11.4.0.2-5512 for Kafka
- JR61641 REPLICATION TO KAFKA TARGET FAILS FOR BINARY COLUMN AND DYNAMIC FORMATTER
IDR 11.4.0.2-5512 for all LUW engines
- JR61637 CDC STILL TAKES VALUES IN BYTES AFTER CHANGING SYSTEM PARAMETER USEREXIT_MAX_LOB_SIZE_KB UNLESS THE INSTANCE IS RESTARTED
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#
IDR 11.4.0.2-5512 for PostgreSQL
- JR61725 IIDR FOR POSTGRESQL FAILS TO RECONNECT TO DATABASE AFTER A JDBC CONNECTION FAILURE FOR LARGE TRANSACTIONS
- JR61682 CDC FOR POSTGRESQL FAILS TO PARSE DATA WHEN ROW CONTAINS COLUMNS WITH SINGLE-QUOTES AND UNLOGGED COLUMNS
- JR61724 IIDR CDC FOR POSTGRESQL COMMAND DMSETPOSTGRESQLFLUSHLSN FAILS WITH SYNTAX ERROR FOR POSTGRESQL DATABASE VERSIONS BELOW 10
Bug fixes in IDR 11.4.0.2-5512
IDR 11.4.0.2-5512 for Db2 for z/OS remote source
- Resolved replication stops with IFI error code 8 reason code 00E60866 after upgrading to IDR 11.4.0.2-5506.
IDR 11.4.0.2-5512 for Kafka
- Decimal floating point numbers are now written to a topic with an exponent when dynamic formatter is used
IDR 11.4.0.2-5512 for all LUW engines
- 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-5512 for SQL Server
- Addressed NullPointerException in configuration tool when testing AlwaysOn transaction log backup candidates in AlwaysOn configuration tab
IDR 11.4.0.2-5507
Enhancements in IDR 11.4.0.2-5507
IDR 11.4.0.2-5507 for all LUW engines
- dmsupportinfo command line utility collects replication product traces using an optimized algorithm to speed up data collection
IDR 11.4.0.2-5507 for 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
APARs in IDR 11.4.0.2-5507
IDR 11.4.0.2-5507 for MySQL source
- JR61575 TO FILTER OUT THE INDEX FILE IF IT'S HAVING THE SAME PATTERN AS MYSQL BINARY LOGS TO AVOID THE NUMBER FORMAT EXCEPTION.
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.
IDR 11.4.0.2-5507 for PostgreSQL
- JR61600 IIDR FOR POSTGRESQL SOURCE REPLICATION FAILS WHEN A STRING COLUMN HAS MORE THAN ONE SINGLE QUOTE
Bug fixes in IDR 11.4.0.2-5507
IDR 11.4.0.2-5507 for Kafka
- Allow Configurable Client and Group ID Kafka Client Properties in IDR Kafka's kafkaproducer.properties and in Transactionally Consistent Consumer's properties file.
IDR 11.4.0.2-5506
Enhancements in IDR 11.4.0.2-5506
IDR 11.4.0.2-5506 for Db2 for z/OS remote source
- IIDR now supports Turkish EBCDIC CCSID 1026.
- The log reader now commits periodically to avoid holding Db2 locks indefinitely. A new parameter, mirror_log_read_commit_interval_seconds, is available to configure the log reader commit interval.
IDR 11.4.0.2-5506 for all LUW engines
- 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.
IDR 11.4.0.2-5506 for Oracle
- IDR now support Oracle SecureFile LOB.
APARs in IDR 11.4.0.2-5506
IDR 11.4.0.2-5506 for Datastage
- JR61394 AN ERROR OCCURRED IN USER EXIT FOR TABLE CUST.TS_CLOUDANT. ERROR: [NULL]
IDR 11.4.0.2-5506 for Kafka
- JR61492 SUBSCRIPTION HITS NPE WHEN ENABLE GLOBAL TRACE
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
IDR 11.4.0.2-5506 for SQL Server
- JR61535 CDC UPGRADE FAILS WITH MIGRATION ERROR WHEN USING INTEGRATED SECURITY
Other changes in IDR 11.4.0.2-5506
IDR 11.4.0.2-5506 for Flexrep
- Remove implied dependency on database connection property "clientapplicationinformation"
IDR 11.4.0.2-5503
Enhancements in IDR 11.4.0.2-5503
IDR 11.4.0.2-5503 for Db2 for z/OS remote source
- IIDR for Db2 for z/OS remote source now supports WLM environments and data sets containing at (@), hash (#) and dollar ($) characters.
IDR 11.4.0.2-5503 for Kafka
- IIDR for Kafka now migrates Kafka SSL/TLS configuration from dmts64.vmargs to an encryption profile.
- Subscription now stops properly after Kafka producer throws an exception
IDR 11.4.0.2-5503 for all LUW 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.
IDR 11.4.0.2-5503 for MySQL source
- IDR for MySQL now supports MySQL community edition as source.
IDR 11.4.0.2-5503 for Oracle
- IDR for oracle now supports oracle 19c for source engines as well as target engines
IDR 11.4.0.2-5503 for PostgreSQL
- IDR for PostgreSQL now has a new command to set the flushed LSN position for logical replication slot
APARs in IDR 11.4.0.2-5503
IDR 11.4.0.2-5503 for Db2 LUW
- JR61446 IDR FOR DB2LUW WILL NOW REPORT PRIMARY CONSTRAINTS AS PRIMARY INDEXES IN CHCCLP LIST TABLE INDEXES COMMAND
IDR 11.4.0.2-5503 for all LUW engines
- JR61380 "ARITHMETICEXCEPTION DIVIDE BY 0" IS THROWN WHEN ONLY DERIVED COLUMN ARE SET FOR REPLICATION
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.
IDR 11.4.0.2-5503 for PostgreSQL
- JR61457 IIDR FOR POSTGRESQL ENCOUNTERS OUT OF MEMORY EXCEPTION FOR LARGE TABLE REFRESH
IDR 11.4.0.2-5503 for SQL Server
- JR61375 POSSIBLE DATA LOSS AFTER EVENT ID 2903 "AN EXCEPTION HAS OCCURRED IN THE LOG PARSER."
Bug fixes in IDR 11.4.0.2-5503
IDR 11.4.0.2-5503 for Db2 for z/OS remote source
- The GUI configuration tool now preserves the user prefix when it prompts for the database password.
IDR 11.4.0.2-5503 for SQL Server
- NullPointerException in SectorGroupSlotArray no longer occurs on the first log block
Other changes in IDR 11.4.0.2-5503
IDR 11.4.0.2-5503 for all LUW engines
- dmshowversion now shows master instead of Release in the Build field.
IDR 11.4.0.2-5503 for SQL Server
- IIDR now supports the new storage location of the publisher ID in Microsoft SQL Server 2016 SP2 CU3 and higher and SQL Server 2017 CU6 and higher.
IIDR 11.4.0.2-5130 for all LUW engines
IIDR 11.4.0.2-5130 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5130 for all LUW engines
Display the protocol and cipher suite in an event on the source and target.
IIDR 11.4.0.2-5130 for Oracle
Support replicating Oracle extended data type columns
JR61321 IIDR ORACLE ENGINE USING RULE BASED / DDL REPLICAITON MAPPING RECEIVING IN-LINE DESCRIBE MSG MAY CAUSE PREMATURE COMMIT .
JR61342 IIDR RULES BASED REPLICATION PATTERN CONFLICT CAN RESULT IN TABLE DATA NOT BEING REPLICATED.
Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%3FInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.2-5128 for all LUW engines
IIDR 11.4.0.2-5128 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5128 for PostgreSQL
IIDR for PostgreSQL now supports PostgreSQL database v11.
JR61274 POSTGRESQL AS SOURCE: PARSE EXCEPTION FOR COMMIT TIMESTAMP
IIDR 11.4.0.2-5128 for Oracle
JR61286 NPE AFTER UPGRADE TO BUILD 11.4.0.2-5125 ON STARTING ASM CONNECTION FROM LOG READER.
IIDR 11.4.0.2-5128 for DataStage
JR61230 IIDR FOR DATASTAGE TO CLOUDANT DOES NOT INCLUDE TLS1.2 IN PROTOCOL LIST.
IIDR 11.4.0.2-5128 for MySQL source
The CDC Replication Engine for MySQL source is a new replication engine for IBM Data Replication as of version 11.4.0.2.
This engine provides full source-side replication capability for MySQL.
IIDR 11.4.0.2-5128 for Db2 for z/OS remote source
IIDR for Db2 for z/OS remote source now allow more flexible configuration options for user high level qualifiers and language environment location.
Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%3FInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.2-5125 for all LUW engines
IIDR 11.4.0.2-5125 for all LUW engines
JR61177 WHEN USING CONFLICT RESOLUTION OR ADAPTIVE APPLY AND MAPPING TO DATABASE DEFAULT, NOT NULL COLUMNS ARE ENTERED AS NULL.
IIDR 11.4.0.2-5125 for Oracle
IIDR CDC Replication Engine for Oracle can now connect to an Oracle database that uses ASM over TCPS. You can configure this using the configuration tool's 'advanced parameters for ASM connection'.
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5124 for all LUW engines
IIDR 11.4.0.2-5124 for all LUW engines is available on FixCentral.
JR61173 CDC UPGRADE MAY FAIL WITH MIGRATION ERROR FOR SECRETSTORE WHEN CDC INSTALLATION IS HAVING MORE THEN ONE INSTANCE
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5123 for all LUW engines
IIDR 11.4.0.2-5123 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5123 for Netezza, Db2
JR61101 ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN INSERTS/UPDATES WITH COLUMNS THAT HAVE MAX COLUMN LENGTH GREATER THAN 64K
IIDR 11.4.0.2-5123 Db2 for z/OS Remote Source
Added support for Db2 12.1.100 (migration from Db2 11)
Greater throughput capturing Db2/z log records using larger in-memory and network buffers. [Validated by client beta testing, more than 3x improvement]
Lower mainframe CPU usage for high volume workloads, seen as reduced MIPS with additional zIIP off load. [Validated by client testing, dramatic MIPS savings]
IIDR 11.4.0.2-5123 for Netezza
JR61166 CREATING AN INSTANCE ON CDC NETEZZA FAILS IF A SCHEMA WITH THE SAME NAME AS THE DATABASE USER ID CANNOT BE CREATED/ACCESSED
IIDR 11.4.0.2-5123 for Oracle
JR61144 IIDR ORACLE LOG PARSER WRITING TOO MANY TRACE MESSAGES
IIDR 11.4.0.2-5123 for Kafka
JR61163 REFRESHING OR MIRRORING LOBS CAN LEAD TO THE CDC KAFKA TARGET ENGINE SHUTTING DOWN DUE TO OUT OF MEMORY OR TOO MANY OPEN FILES
IIDR CDC Replication Engine for Kafka now supports TIMESTAMP-MICROS, TIME-MILLIS, DATE and DECIMAL data types, and provides new options for formatting these data types.
System parameter mirror_write_format: Use this system parameter to enable dynamic formatting.
LEGACY (default): Use legacy formatting.
DYNAMIC: Enable dynamic formatting
System parameter mirror_timestamp_write_format: Use this system parameter to specify how timestamp values should be formatted. The parameter requires mirror_write_format to be set to the value DYNAMIC.
AVRO (default): Formats TIMESTAMP column values as the number of microseconds from the unix epoch, 1 January 1970 (ISO calendar). For the purpose of this calculation, the timestamps are assumed to be UTC. For TIMESTAMP columns with precision greater than microseconds the values are formatted as strings. You can specify the string format using timestamp_format. Formats TIMESTAMP WITH TIMEZONE column values as strings. You can specify the string format using timestamp_tz_format.
STRING: Formats TIMESTAMP column values as strings. You can specify the string format using timestamp_format. Formats TIMESTAMP WITH TIMEZONE column values as strings. You can specify the string format using timestamp_tz_format.
System parameter mirror_time_write_format: Use this system parameter to specify how time values should be formatted. The parameter requires mirror_write_format to be set to the value DYNAMIC.
AVRO (default): Formats TIME column values as the number of milliseconds after midnight, '00:00:00 00.000'.
STRING: Formats TIME column values as strings. You can specify the string format using time_format
System parameter mirror_date_write_format: Use this system parameter to specify how date values should be formatted. The parameter requires mirror_write_format to be set to the value DYNAMIC.
AVRO (default): Formats DATE column values as the number of days from the unix epoch, 1 January 1970 (ISO calendar).
STRING: Formats DATE column values as strings. You can specify the string format using date_format.
System parameter mirror_decimal_write_format: Use this system parameter to specify how fixed point decimal values should be formatted. The parameter requires mirror_write_format to be set to the value DYNAMIC.
AVRO (default): Formats fixed point decimal column values as byte arrays.
STRING: Formats fixed point decimal column values as strings.
Here is the link to the Fix Central page.
IDR 11.4.0.2-5121 for all LUW engines
IDR 11.4.0.2-5121 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5121 for Kafka
JR61163 REFRESHING OR MIRRORING LOBS CAN LEAD TO THE CDC KAFKA TARGET ENGINE SHUTTING DOWN DUE TO OUT OF MEMORY OR TOO MANY OPEN FILES
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5120 for all LUW engines
IIDR 11.4.0.2-5120 for all LUW engines is available on FixCentral
JR61162 REFRESH OR MIRRORING LOBS CAN LEAD TO TARGET ENGINES SHUTTING DOWN DUE TO 'OUT OF MEMORY' OR 'TOO MANY OPEN FILES'.
IIDR 11.4.0.2-5120 for PostreSQL source
PostgreSQL running on Amazon RDS is now supported as a source engine.
IIDR 11.4.0.2-5120 for Db2 (LUW)
IBM Db2 Warehouse and Db2 Warehouse on Cloud database Row Organized tables are now supported by the source engine. Replicating from Column Organized tables is not yet supported.
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5119 for all LUW engines
IIDR 11.4.0.2-5119 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5119 for Oracle
JR61084 IIDR ORACLE ENGINE MAY REPORT METADATA NOT FOUND WHEN IN MANUAL LOG SHIPPING MODE.
IIDR 11.4.0.2-5119 for Teradata
JR61105 CDC FOR TERADATA ADAPTIVE APPLY UPDATES ARE SLOW EVEN WHEN MIRROR_UPDATE_EXCLUDE_UNCHANGED_PRIMARY_INDEX_COLUMNS = TRUE
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5118 for all Linux, Unix and Windows engines
IIDR 11.4.0.2-5118 for all Linux, Unix and Windows engines is available on FixCentral.
IIDR 11.4.0.2-5118 for Microsoft SQLServer
The Replication Engine for Microsoft SQLServer now supports Azure SQL Managed Instance for target engines.
IIDR 11.4.0.2-5118 for Oracle
JR61076 MEMORY USAGE CAN GROW OVER TIME DUE TO MEMORY LEAK
The Replication Engine for Oracle now supports Oracle 18c for source engines as well as target engines.
The Replication Engine for Oracle now supports the Oracle system parameter 'exafusion_enabled' which is used on Linux Exadata systems running ASM.
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5117 for all Linux, Unix and Windows engines
IIDR 11.4.0.2-5117 for all Linux, Unix and Windows engines is available on FixCentral.
IIDR 11.4.0.2-5117 for Db2 for Linux, UNIX and Windows
The Replication Engine for Db2 for Linux, UNIX and Windows can now replicate changes to Db2 Warehouse on Cloud (Entry Plan) for target engines. Replication of 'row organized' tables in Entry Plan is supported; column organized tables are not.
IIDR 11.4.0.2-5117 for Kafka
JR60949 BOOKMARK GETS STUCK WHEN REPLICATING TO MULTI-PARTITION TOPIC
The Replication Engine for Kafka now includes an integrated Kafka custom operation processor 'KcopSingleRowAvroAuditHeadersIntegrated'. It is an avro binary producing KCOP that writes an audit of before and after images for a DML change onto a single row. In addition, it allows a user to specify content for the 'header' field that is optional in a Kafka producer record for Apache Kafka 0.11 and higher.
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5114 for all LUW engines
IIDR 11.4.0.2-5114 for all LUW engines is available on FixCentral
IIDR 11.4.0.2-5114 Db2 for z/OS remote source
Minor enhancements.
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5113 for all LUW engines
IIDR 11.4.0.2-5113 for all LUW engines is available on FixCentral
IIDR 11.4.0.2-5113 for Oracle
JR60962 DMARCHIVELOGREMOVED COMMAND DOES NOT CORRECTLY USE THE -T -Q COMMAND PARAMETERS
IIDR for Oracle now supports Oracle 18c as target
Here is the link to the Fix Central page.
IIDR 11.4.0.2-5111 for all LUW engines
IIDR 11.4.0.2-5111 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5111 for Oracle
CDC Replication Engine for Oracle now supports virtual columns when tables are mapped in rules based subscriptions.
IIDR 11.4.0.2-5111 for Oracle, Db2 LUW
JR60808 RULE-BASED SUB WITH A TABLE WITH A COLUMN COMMENT WHOSE LENGTH IS > 50 CHARS FAILS WITH 'STRING DATA RIGHT TRUNCATION' ERRORS
Here is the link to the Fix Central page.
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%3FInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.2-5105 for all LUW engines
IIDR 11.4.0.2-5105 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5105 for Oracle
CDC Replication Engine for Oracle now handles 'DEFAULT ((0)) NOT NULL' columns when rules based subscriptions are used.
JR60919 'ROW ALREADY EXISTS' ERROR CAN OCCUR WHEN MAPPING A TABLE
Here is the link to the Fix Central page.
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%3FInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.2-5103 for all LUW engines
IIDR 11.4.0.2-5103 for all LUW engines is available on FixCentral.
Corrects an issue when connecting to a database with TLS (EncryptionMethod=SSL property), where the connection would fail with a 'not found' error.
Here is the link to the Fix Central page.
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm˜Information%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4.0.2&platform=All&function=all
IIDR 11.4.0.1-5101 for all Linux, UNIX, and Windows engines
IIDR 11.4.0.1-5101 for all Linux, UNIX, and Windows engines is available on FixCentral.
All Linux, UNIX, and Windows engines
You can now use TLS to encrypt communication between the source and target in all CDC Replication Java engines. You can use self-signed certificates, a central self-signed certificate authority, or a public certificate authority to create private key stores and trust stores within CDC Replication, or use third-party tools such as openssl. To create and manage encryption profiles that are needed to enable or disable encryption, you can use Management Console or the command-line configuration utility.
The JRE included with the engines has been upgraded to IBM Java 8.0.5.26.
CDC Replication Engine for Oracle databases
The CDC Replication Engine for Oracle databasescan now replicate data that uses Transparent Data Encryption. Both column encryption and table space encryption are supported. To replicate encrypted data, you must provide an Oracle master key. For an Oracle 12c container database, CDC Replication needs both the root database master key and the pluggable database master key. Transparent Data Encryption is supported from Oracle 11gR2 and later.
Here is the link to the Fix Central page.
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm˜Information%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4.0.2&platform=All&function=all
IIDR 11.4.0.2-5099 for all LUW engine
IIDR 11.4.0.2-5099 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5099 for Db2 for z/OS remote source
Replication no longer ends with 'Update after image without a before image error'.
Datastore no longer stops on 'Unrecognized operation type'.
Decompression errors now include both the reason and a diagnostic code.
IIDR 11.4.0.2-5099 for Oracle
CDC for Oracle can be installed on any supported platform (Linux/AIX/Windows) and use remote log reading configuration to process logs from Oracle installed on other operating systems (Solaris/HPUX/AIX/Linux/Windows). The operating system for CDC for Oracle and the operating system for the database no longer need to have the same endian-ness, i.e. both little-endian or both big-endian. CDC for Oracle now supports having different endian-ness for the engine and database.
IIDR 11.4.0.2-5099 for PostgreSQL source
The CDC Replication Engine for PostgreSQL sources is a new replication engine for IBM Data Replication as of version 11.4.0.2.
This engine provides full source-side replication capability for PostgreSQL. The replication engine is installed on a distributed platform (Linux, UNIX, or Windows) and after initial setup is entirely administered and maintained on that platform. The product interacts with PostgreSQL are through a standard JDBC interface by using a product-supplied replication API to obtain PostgreSQL log data.
IIDR 11.4.0.2-5099 for SQL Server
JR60561 READPOSITION <POSITION> LAST BACKUP POSITION. LOADED METADATANOT SUFFICIENT
IIDR 11.4.0.2-5099 for Teradata
System parameter mirror_update_exclude_unchanged_primary_index_columns added. This is a boolean parameter. The default is false. If true, a primary index column is only included in the update set clause if it changed.
IIDR for Teradata now supports Teradata 16.2
Here is the link to the Fix Central page.
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm˜Information%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4.0.2&platform=All&function=all
IIDR 11.4.0.2-5098 for all LUW engines
IIDR 11.4.0.2-5098 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5098 for Kafka
JR60515 AN UNCAUGHT EXCEPTION HAS OCCURRED 'THERE IS NO LIST OF STATE TRACKERS FOR LOGICAL TOPIC'
Here is the link to the Fix Central page.
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm˜Information%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4.0.2&platform=All&function=all
IIDR 11.4.0.2-5096 for all LUW engines
IIDR 11.4.0.2-5096 for all LUW engines is available on FixCentral.
IIDR 11.4.0.2-5096 for SQLServer
JR60468 IIDR FAILS WITH EXCEPTION “CANNOT INSERT VALUE NULL” WHEN PROCESSING TABLE LEVEL AUDIT MESSAGES
IIDR 11.4.0.2-5096 for Oracle
JR60461 THE DMSHOWLOGDEPENDENCY COMMAND IS GIVING INCORRECT STATUS IN OUTPUT WHEN IT RAN AGAINST RAC.
JR60483 CDC ORACLE REDO LOG SCRAPER CAN INCORRECTLY DECLARE REDO LOG AS CORRUPTED
Here is the link to the Fix Central page.
https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm~Information%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4.0.2&platform=All&function=all
IIDR 11.4.0.2-5095 for all LUW engines
IIDR 11.4.0.2-5095 for all LUW engines is available on FixCentral.
The version has changed from 11.4.0.1 to 11.4.0.2 because updated open source libraries are included in this build. See the notices file in your installation directory for a listing of the open source libraries included in this product.
IIDR 11.4.0.2-5095 for Db2 for z/OS remote source
Improved parsing of compressed log records and compressed tablespaces.
Enhanced the product to include more detailed information about possible decompression error, including the reason and diagnostic code.
IIDR 11.4.0.2-5095 for Kafka
JR60403 CUSTOM KCOP NECESSITY EXCEPTION THE ERROR VALUE IS 'THERE IS NO LIST OF STATE TRACKERS FOR LOGICAL TOPIC'
Updated the Kafka libraries to 1.1.1.
Persistent subscriptions now have the ability to restart when a KCOP error is generated.
IIDR 11.4.0.2-5095 for SQLServer
SMO cannot initialize with Azure SQL Database with a user that does not have access to the master database
IIDR 11.4.0.2-5095 for Teradata
JR60427 IIDR TERADATA FAILS TO MAP TABLES WITH COLUMN NAME > 30CHARS
IIDR for Teradata fails with a NullPointerException while collecting support info
Here is the generated link to the Fix Central page.
IIDR 11.4.0.1-5091 for all LUW engines
IIDR 11.4.0.1-5091 for all LUW engines is available on FixCentral.
JR59656 SCHEDULED END BY TIME DOES NOT WORK WHEN THE SOURCE DATABASE BEING 100% IDLE
IIDR 11.4.0.1-5091 for SQL Server
JR60393 OUTOFMEMORY ERROR SEEN WITH NO TRACING HAPPENING
JR60411 WHEN REBUILDING MANY INDEXES, CDC MAY END REPLICATION ON ERROR WITH NECESSITYEXCEPTION
IIDR 11.4.0.1-5091 for Oracle
JR59759 IIDR FOR ORACLE REPORTS LOG NOT AVAILABLE AND STOPS MIRRORING WHEN SEQUENCE GAP OCCURS IN ARCHIVE ONLY MODE
JR60086 UNEXPECTED OPERATION FOR UPDATE ON ORACLE TABLE WITH EXISTING 'FAST COLUMN ADD ' COLUMN
Here is the link to the Fix Central page.
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.1-5089 for all LUW Engines
IIDR 11.4.0.1-5089 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.1-5089 for Db2 for z/OS Remote Source
he CDC Replication Engine for Db2® for z/OS® Remote Source is a new replication engine for IBM® Data Replication as of version 11.4.0.1. This engine provides full source-side replication capability for Db2 for z/OS with a minimal footprint on z/OS. The replication engine is installed on a distributed platform (Linux, UNIX, or Windows) and after initial setup is entirely administered and maintained on that platform.
This configuration is easier to use because you do not have to log in or monitor replication on the mainframe, and it enables significantly lighter resource utilization on the mainframe including CPU.
The product’s interactions with Db2 for z/OS are through standard JDBC interfaces using a product-supplied stored procedure to obtain Db2 for z/OS log data. After a one-time setup of the stored procedure environment, no operator or administrator involvement is required directly on z/OS. Upgrades to the product, including applying maintenance to the stored procedure code, are performed entirely on the distributed platform without the need for Db2 or z/OS-specific skills. Any needed updates to the stored procedure are performed automatically and securely by the engine through SSH.
For more information, see Knowledge Center https://www.ibm.com/support/knowledgecenter/SSTRGZ_11.4.0/com.ibm.cdcdoc.cdcdb2zremote.doc/concepts/overview.html
Please contact your IBM sales representative or business partner for details on how to purchase this engine.
Here is the link to the Fix Central page.
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.1-5088 for all LUW engines
IIDR 11.4.0.1-5088 for all LUW engines is available on FixCentral
IIDR 11.4.0.1-5088 for Oracle
JR60138 CDC HIT NECESSITYEXCEPTION WHEN TRYING TO READ LOCAL ARCHIVED LOG FROM EXADATA SOURCE
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.1-5086 for all LUW Engines
IIDR 11.4.0.1-5086 for all LUW Engines is available on FixCentral.
JR60208 NULLPOINTEREXCEPTION WHEN RUNNING DMSHOWEVENTS COMMAND
IIDR 11.4.0.1-5086 for Db2
JR60275 NON-EMPTY BLOB DATA IS BEING REPLICATED AS EMPTY BLOB DATA
IIDR 11.4.0.1-5086 for Oracle
Target engine support added for extended DataTypes ( varchar/nvarchar(4000+ > 32k) or raw(2000 > 32k))
IIDR 11.4.0.1-5086 for Kafka
Enhanced KcopJsonFormatIntegrated to write to multiple partitions
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.1-5085 for all LUW engines
IIDR 11.4.0.1-5085 for all LUW engines is available on FixCentral
IIDR 11.4.0.1-5085 for SqlServer
JR60170 NULLPOINTEREXCEPTION WHEN CONFIGURING IIDR CDC INSTANCE FOR MSSQL SERVER ALWAYSON SETUP
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.1-5084 for all LUW engines
IIDR 11.4.0.1-5084 for all LUW engines is available on FixCentral.
IIDR 11.4.0.1-5084 for Oracle
JR59664 FIX EXTRACTING DATABASE CONTAINER INFORMATION IN CASE OF NON-CDB ON 12C.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5079 for all LUW engines
IIDR 11.4.0.0-5079 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5079 for Oracle
JR60018 NCLOB COLUMN NOT REPLICATED ACCURATELY WHEN THE DATABASE NATIONAL CHARACTER ENCODING IS UTF-8.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5078 for all LUW engines
IIDR 11.4.0.0-5078 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5078 for Microsoft SQLServer
JR59762 MEMORY AND FILE LEAK FOR A TABLE WITH MORE THAN ONE CLOB/LOB COLUMNS
JR60021 NULLPOINTEREXCEPTION WHEN NO TABLE CONTEXT IS FOUND
IIDR 11.4.0.0-5078 for Oracle
JR59471 FOR CDC ORACLE AS TARGET, APPLY SHOULD PUT LOB COLUMN AT THE END DUE TO ORACLE DB RESTRICTION
JR59695 EXCESSIVE TRACING FOR NORMAL INSTANCE WHEN REACHING HOL WHILE THE DB IS IDLE
JR59752 DMSHOWLOGDEPENDENCY RETURNS INCOMPLETE LIST OF LOGS WHEN RAC_CLUSTER_NODE_LIST PARAMETER IS SET.
JR59762 MEMORY AND FILE LEAK FOR A TABLE WITH MORE THAN ONE CLOB/LOB COLUMNS
IIDR 11.4.0.0-5078 for Oracle enhancement
The CDC Replication Engine for Oracle as a source engine now has improved performance for workloads where the source database commit size is large, the table is wide and the table is partitioned. For details on how to enable this improved handling, please contact your CDC representative.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5069 for all LUW Engines - enhancements
In addition to the defect fixes announced for 11.4.0.0-5069, a number of enhancements were also made available in this build.
IIDR 11.4.0.0-5069 for Db2
IIDR 11.4.0.0-5069 for Db2 introduces two enhancements - improved database connection options for Db2 LUW databases, and mirror bulk apply for IIAS databases.
Improved database connection options (Type 4)
IIDR CDC for Db2 now provides you with the option to use Type 4 JDBC connections as the method by which the replication engine connects to Db2.
What are the benefits of using Type 4?
- For remote databases, you no longer need to catalog the database prior to refresh (using JDBC method).
- When a database is SSL-enabled, you can configure JDBC Type4 advanced parameters to have all CDC connections to the database secured.
- Using Type4, you can leverage Db2 features such as WLB (Work Load Balancing) used by PureScale databases.
For more information, please see Adding an instance of the CDC Replication Engine for Db2 for LUW (Windows)
Please note that CDC uses only native connections for Source capture (reading database logs using db2readlog api) and Fast load (db2load) Apply as db2readlog and db2load apis require native connections. But for any Db2 metadata queries Type4 connections can be used.
Mirror bulk apply
IIDR CDC for Db2 now offers mirror bulk apply (MBA) for IBM Integrated Analytics System targets, providing up to 100x RPS throughput over Fast Apply and up to 150x RPS throughput over standard JDBC apply.
What is it?
IIDR CDC provides support to Db2 Warehouse/on Cloud and IBM Integrated Analytics System (IIAS) targets. Mirror bulk apply is a new way to apply to IIAS databases that employs the external table feature available for IIAS. You can configure it using user exits in a similar fashion to IIDR CDC fast apply.
Test results
The workload consists of Insert Update and Delete operations with apply threads set to 3, latency threshold set to 60 seconds, commit size set to 100 transactions and 410mb of transaction length. In this test we used mirror bulk apply with External Table. The IIAS box is 'network near' or in other words, with minimum number of hops. The test uses JDBC type 4 connection, another new feature available in IIDR CDC v11.4.0.0-5069.
Below is a graph of the throughput using Mirror bulk apply along with a comparison with Fast apply and standard CDC apply.
Disclaimer:
The above test is performed in a controlled/development environment the results shown only for reference and the results may vary in actual environments like production.
For more information, please see External table mirror bulk apply .
IIDR 11.4.0.0-5069 for Microsoft SqlServer
Remote source for the CDC Replication Engine for Microsoft SqlServer
IIDR CDC for Microsoft SqlServer now offers you the option to configure a replication engine that is remote from the source database, where the CDC engine does not have direct access to the database's transaction logs. This allows you to install CDC on a separate system from the Microsoft SqlServer database, allowing better resource management and access control.
This version of CDC for Microsoft SqlServer supports several configurations where you can run IBM CDC for Microsoft SQL Server replication engine as a source datastore on a remote system from the SqlServer database, using:
- a script to copy transaction log backups to the replication engine; or,
- a shared directory containing transaction logs; or
- an alternate location for transaction logs than the location used to back up the logs.
For more information, please see Configuring a remote source of the CDC Replication Engine for Microsoft SQL Server.
In addition, IIDR CDC for Microsoft SqlServer has reduced the privileges needed to operate a source datastore. It is no longer necessary for the CDC instance user to be granted the sysadmin role, or to be the owner of a trusted database. Now, the CDC instance user only needs to be granted the database ownership role plus several other statements. IIDR CDC for Microsoft SqlServer comes with sample scripts, grantuser-sql-nosa.sql and enablerepl-sql-nosa.sql, for granting these privileges.
For further details, please see Required database, user accounts, and schemas.
IIDR 11.4.0.0-5074 for all LUW engines
IIDR 11.4.0.0-5074 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5074 for Oracle and Microsoft SqlServer engines
JR59762 MEMORY AND FILE LEAK FOR A TABLE WITH MORE THAN ONE CLOB/LOB COLUMNS
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5069 for all LUW Engines
IIDR 11.4.0.0-5069 for all LUW Engines is available on FixCentral.
JR59577 WHEN INDEX CREATION IS CANCELLED, IIDR STOPS WITH EVENTMESSAGE 9505
JR59656 SCHEDULED END BY TIME DOES NOT WORK WHEN THE SOURCE DATABASE BEING 100% IDLE
IIDR 11.4.0.0-5069 for Cloudant (DataStage engine)
JR59666 CLOUDANT: SUBSCRIPTION ENDS ON NULLPOINTEREXCEPTION WHEN NOSQL_APPLY_NUMBER_OF_APPLY_THREADS IS SET LARGER THAN 1
IIDR 11.4.0.0-5069 for Oracle
* Improved performance of derived expression %TODIFFERENTTIMEZONE
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5067 for all LUW Engines
IIDR 11.4.0.0-5067 for all LUW Engines is available on FixCentral
IIDR 11.4.0.0-5067 for Db2 LUW
JR59444 CANNOT MAP TABLE WITH BOOLEAN DATA TYPE ON AIX PLATFORM
IIDR 11.4.0.0-5067 for Oracle
JR59192 SUPPORT SUPPLEMENTAL LOG INFO AVAILABILITY IN CASE OF A SYSTEM TABLE.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5066 for all LUW engines
IIDR 11.4.0.0-5066 for all LUW engines is available on FixCentral.
RFE 119094 Enhanced event 317 that is logged when an insert, update or delete fails to replicate. The event now provides the BEFORE image for failed UPDATE or DELETE operations in order to troubleshoot apply issues by comparing the key value in the event with the source table operations.
IIDR 11.4.0.0-5066 for Oracle
JR58881 CDC IS REPLICATING NULL FOR TRAILING COLUMN WHEN TABLE USING COMPRESS METHOD AS COMPRESS FOR OLTP LOGGING
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5065 for all LUW engines
IIDR 11.4.0.0-5065 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5065 for Kafka
JR59489 NUMBER OF THREAD WRITERS CAP IS NOT BEING OBEYED WHEN SETTING SYSTEM PARAMETER 'KAFKA_TARGET_NUMBER_OF_WRITERS' TO NON 0 VALUE
JR59507 KAFKATARGETBINARYWRITER THROWS NULLPOINTER EXCEPTION
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5064 for all LUW engines
IIDR 11.4.0.0-5064 for all LUW engines is available on FixCentral
JR59352 JAVA.LANG.ASSERTIONERROR: UNABLE TO UNLOCK JDBC DRIVER, AFTER MIGRATION FROM 11.3.3-GA
IIDR 11.4.0.0-5064 for FlexRep
Support is now available for MySQL 5.7.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5063 for all LUW engines
IIDR 11.4.0.0-5063 for all LUW engines is available on FixCentral
JR59420 IIDR CAN FAIL DURING RUN TIME WHEN EVALUATING AN EXPRESSION WITH MULTIPLE NESTED %IF BLOCKS.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5062 for all LUW engines
IIDR 11.4.0.0-5062 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5062 for Db2 LUW
* Configuration tool dmconfigurets failed when run in interactive mode
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5059 for all LUW engines
IIDR 11.4.0.0-5059 for all LUW engines is available on FixCentral
IIDR 11.4.0.0-5059 for Db2 for LUW
JR59346 THE NPE HAPPENS WHEN THE LOB RECORDS ARE COMING BEFORE THE DMSRECORDS.
JR59412 ERROR 'SQL0604N' DURING REFRESH
IIDR 11.4.0.0-5059 for Oracle
JR58954 CHOOSE THE MINIMUM RESTART POSITION AND THE MINIMUMCOMMIT+CURRENT INDEPENDENTLY FOR GROUP START
JR59415 OUTOFMEMORYERROR IS HIT WHEN V$ARCHIVED_LOGS CONTAINS MULTIPLE ENTRIES FOR REQUIRED LOG THAT ARE DELETED USING RMAN
IIDR 11.4.0.0-5059 for Microsoft SqlServer
JR59414 DATETIME TIMESTAMPS FROM SQL SOURCE ARE ROUNDED INCORRECTLY DURING MIRRORING
This build contains the following enhancements for Microsoft SQL Server:
- More reliable handling for disk write caching for online logs in IIDR for Microsoft SQL Server.
- Reduces the non-repeatable product behaviour when reading transaction logs, so that the problem determination could be enhanced when problems arise, and the product would behave similarly on repeated tests when reading the same portion of the log.
- Eliminates 'Unknown Log Record Type' errors.
- Provides an alternative to identifying log reading related issues in local environment that does not require sharing the transaction logs in original form for users for whom corporate security requirements do not permit sharing such information with external parties.
- DBCC DBTABLE calls have been reduced and virtually eliminated during continuous log reading.
- Reduces the CPU usage on the database caused by IIDR for Microsoft SQL Server when there is little data modification in the database due to elimination to continuous calls to DBCC DBTABLE.
- Provides a user friendly error if the transaction logs in a database are compressed or encrypted.
- To improve troubleshooting log reading related errors, enhanced tracing now indicates which file IBM CDC for Microsoft SQL Server is reading, and when it switches to an online log file.
- Includes a utility that may permit reading transaction logs from the source disk in isolation from the rest of the replication, to help diagnose read IO speed fluctuations in Virtual Machines.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5058 for all LUW engines
IIDR 11.4.0.0-5058 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5058 for Kafka
JR59305 CONCURRENT KAFKA CALLBACKS CAN CAUSE NULLPOINTEREXCEPTION WHEN UPDATING OFFSETS INFORMATION FOR COMMIT STREAM
JR59308 WHEN KAFKA PRODUCER REPORTS EXCEPTION CDC SHOULD STOP AS SOON AS IT IS REPORTED
The Kafka transactionally consistent consumer is now available.
You can recreate the order of operations in source transactions across multiple Kafka topics and partitions and consume Kafka records that are free of duplicates by including the Kafka transactionally consistent consumer library in your Java applications. When you include this library, the application makes calls to request records for a topic or set of topics that are part of a CDC subscription. The Kafka transactionally consistent consumer provides the records as well as information on the topic, partition, offset, operation ID, and operation bookmark for each record. The operation bookmark can be used to position the application that calls the Kafka transactionally consistent consumer. The application can then process these records in order and duplicate free.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5057 for all LUW engines
IIDR 11.4.0.0-5057 for all LUW engines is available on FixCentral
IIDR 11.4.0.0-5057 for Oracle
JR59296 SOURCE ORACLE CDC ENGINE FAILS WITH EXCEPTION 'NO IMPLEMENTATION SET FOR RAWDATA' WHEN THE OPFAMILY IS NOT 11
JR59307 BEQUEATH CONNECTION ON PHYSICAL STANDBY IS RETURNING FALSE ERROR.
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5054 for all LUW engines
IIDR 11.4.0.0-5054 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5054 for all LUW engines
JR59187 OUT OF MEMORY ERROR POSSIBLE IF ISERIES SOURCE REORGS TABLES MANY TIMES SINCE A SUBSCRIPTION STARTS RUNNING.
IIDR 11.4.0.0-5054 for Db2
System parameter global_trace_utility_create_on_demand has been added. This system parameter limits the trace file generation for utility command execution. It applies to both source and target datastores.
Set this parameter to one of the following values:
true - Trace file for the execution of a utility command will only be created when we have actual information we need to trace, such as an exception.
false - Trace file for a utility will always be created for every utility command execution.
The default setting is false.
IIDR 11.4.0.0-5054 for Kafka
Integrated auditing KCOPs KcopLiveAuditSingleRowIntegrated and KcopMultiRowAvroLiveAuditIntegrated have improved handling for source engines that send journal control fields with null values. KcopLiveAuditSingleRowIntegrated and KcopMultiRowAvroLiveAuditIntegrated no longer throw null pointer exceptions when receiving null journal control field values.
KcopMultiRowAvroLiveAuditIntegrated has added flexibility. Its properties file can now accept the following parameters:
schema.registry - the schema registry url
audit.jcfs - a comma-separated list of journal control field names to be added to each record
before.update.record.mode - New! when to write a record representing the before image of an update (ALWAYS, NEVER, ON_KEY_CHANGE). Default is ALWAYS.
default.null.JCF.value - New! the string value to substitute when a source does not supply a jcf value. By default empty string.
null.UB.ENTTYP.override - New! the specific value to use when a source does not provide an ENTTYP for an update before operation. Default is 'UB'.
For more details, see Knowledge Center.
IIDR 11.4.0.0-5054 for Netezza
JR59182 STUCK BOOKMARK: CDC FOR NETEZZA COMMIT CAN BE DELAYED INDEFINITELY WHEN APPLY IS BUSY
IIDR 11.4.0.0-5054 for Oracle
JR59225 UNPLANNED DDL PERFORMED AGAINST A TABLE THAT IS MAPPED IN ONLY ONE SUBSCRIPTION CAUSES ALL SUBSCRIPTIONS TERMINATION
Here is the link to the FixCentral page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5053 for all LUW engines
IIDR 11.4.0.0-5053 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5053 for Kafka
CDC Replication engine for Kafka is now available on Linux for IBM zSystems
IIDR 11.4.0.0-5053 for Microsoft SqlServer
JR59139 EXCEPTION PERSISTING THE TRANSACTION QUEUE
IIDR 11.4.0.0-5053 for Netezza
JR59146 IIDR CDC FOR NETEZZA CAN NOT FIND PRIMARY KEY FOR MULTI SCHEMA CONFIG
IIDR 11.4.0.0-5053 for Teradata
CDC Replication engine for Teradata is now available on 11.4 as a target datastore. You can find more information in Knowldedge Center (https://www.ibm.com/support/knowledgecenter/SSTRGZ_11.4.0/com.ibm.cdcdo…)
Teradata version 16 is now supported.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5052 for all LUW Engines
IIDR 11.4.0.0-5052 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.0-5052 for Db2
Enhancements:
* IIDR for Db2 now supports BINARY and VARBINARY datatypes on Db2 11.1.
IIDR 11.4.0.0-5052 for Kafka
JR58450 TRUNCATE OR DELETE WITHOUT WHERE CLAUSE KAFKA TARGET FAILS AND UNABLE TO RESTART THE REPLICATION
JR58975 SUBSCRIPTION FAILED TO START AFTER BOOKMARK IS SET WITH DMSETBOOKMARK COMMAND LINE UTILITY
IIDR 11.4.0.0-5052 for Microsoft SqlServer
Enhancements:
* VARBINARY(MAX) with FILESTREAM is now supported for replication.This datatype is used for storing BLOB data on the file system in a FILESTREAM filegroup, rather than in the database file.
* You can use the CDC Replication Engine for Microsoft SQL Server to replicate to a Microsoft Azure SQL Database target.
CDC Replication supports Azure SQL Database as a remote target only. The CDC Replication target can either be installed on premises or in an Azure VM. For optimum performance, the CDC Replication target should be installed on a VM in the same region as the Azure SQL Database. Details can be found in Knowledge Center at https://www.ibm.com/support/knowledgecenter/SSTRGZ_11.4.0/com.ibm.cdcdoc.cdcformssql.doc/concepts/configuringazuresql.html.
* You can use the CDC Replication Engine for Microsoft SQL Server to replicate from a Microsoft SQL Database deployed in a Microsoft Azure VM.
IIDR 11.4.0.0-5052 for Oracle
Enhancements:
* The IIDR Replication Engine for Oracle has improved algorithms for locating and reading log files, and reduced the number of database connections created by the log reader.
* dmshowlogdependency usability was improved.
* Addressed PK constraint violations occurring on metadata table TS_ORACLE_ARCHIVES.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5051 for all LUW engines
IIDR 11.4.0.0-5051 for all LUW engines is available on FixCentral. It includes the following:
IIDR 11.4.0.0-5051 for Oracle
JR58966 CDC ONLY ADDS ONE ENTRY TO THE CACHE LIST, IF THERE ARE MULTIPLE DESTINATIONS
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5050 for all LUW engines
IIDR 11.4.0.0-5050 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5050 for all LUW engines
JR58755 MANAGEMENT CONSOLE CAUSES THE CDC ENGINE TO CRASH WITH AN OOM EXCEPTION.
JR58825 CONTINUALLY GET A 'OBJECT HAS BEEN CLOSED' EXCEPTION ON A PREPARED STATEMENT AFTER AN EXCEPTION OCCURS ON THAT STATEMENT
IIDR 11.4.0.0-5050 for Db2
JR58736 CDC FOR DB2 INSTANCE WITH A LOWERCASE SCHEMA NAME FAILS TO START WHEN CDC IS UPGRADED FROM 10.2.1 TO 11.3.3 GA
IIDR 11.4.0.0-5050 for Kafka
JR58838 CDC FOR KAFKA DOES NOT INVOKE KAFKA PARTITIONER CLASS
IIDR 11.4.0.0-5050 for Microsoft SqlServer
JR58679 DATA REPLICATION STALLS WHEN THERE ARE FREQUENT BACKUPS WHILE REPLICATION IS CLOSE TO THE HEAD OF LOG
IIDR 11.4.0.0-5050 for Oracle
JR58840 PRODUCT IS FAILING WITH NULL POINTER EXCEPTION WHILE GETTING ROWID WHEN ADVANCE COMPRESSION IS USED
JR58892 CDC SKIPPING ARCHIVED/ONLINE LOG
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5049 for all LUW engines
IIDR 11.4.0.0-5049 for all LUW engines is available on FixCentral
IIDR 11.4.0.0-5049 for Oracle
JR58892 CDC SKIPPING ARCHIVED/ONLINE LOG
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5047 for all LUW Engines
IIDR 11.4.0.0-5047 for all LUW engines is now available on FixCentral.
IIDR 11.4.0.0-5047 for Oracle
JR58867 IIDR ORACLE RESTART POSITION IN BOOKMARK DOES NOT MOVE FORWARD
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5046 for all LUW Engines
IIDR 11.4.0.0-5046 for all LUW engines is now available on FixCentral.
IIDR 11.4.0.0-5046 for Oracle
JR58814 PRODUCT IS FAILING WITH FALSE DDL ERROR AND HAVING ARRAYINDEXOUTOFBOUNDEXCEPTION IN TRACES.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5045 for all LUW engines
IIDR 11.4.0.0-5045 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5045 for Db2 LUW
JR58470 ROW FILTERING FAILS WHEN BIGINT DATATYPE USED WITH LARGE NUMBER GREATER THAN 10 DIGITS
IIDR 11.4.0.0-5045 for Kafka
* Now supports Kafka custom operation processors
* You can write audit records in comma-separated values (CSV) format by using the KcopLiveAuditSingleRowIntegrated Kafka custom operation processor.
* You can write records in JSON format by using the KcopJsonFormatIntegrated Kafka custom operation processor. No schema registry required!
* You can specify topic names and set up mappings between multiple source tables and target topics by using the KcopTopicMappingIntegrated Kafka custom operation processor.
* The KcopMultiRowAvroLiveAuditIntegrated Kafka custom operation processor can write audit records in Avro format and register the schema in a Confluent schema registry or a Hortonworks Schema Registry Service that uses its Confluent emulation mode.
* You can develop a user-defined Kafka custom operation processor to suit your needs using the samples provided.
* Videos are available on DeveloperWorks
* Documentation is available on IBM Knowledge Center
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5044 for all LUW engines
IIDR 11.4.0.0-5044 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5044 for all LUW engines
JR58697 &JOBUSER CONTAINS INVALID VALUE '='. This issue affects target datastores.
IIDR 11.4.0.0-5044 for Microsoft SqlServer
* Now supports Microsoft SqlServer 2017 as a source or a target
IIDR 11.4.0.0-5044 for Oracle
* Now supports replicating from source tables that use the Oracle Interval Partition feature, where partitions are automatically added. On Oracle 12cR2, IIDR now supports Auto-List Partitioning as well.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5042 for all LUW engines
IIDR 11.4.0.0-5042 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5042 for Oracle
JR58686 IIDR CDC IS FAILING TO GET LOG FILE WHEN ONLINE LOG IS GETTING ARCHIVED.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5040 for all LUW engines
IIDR 11.4.0.0-5040 for all LUW engines is available on FixCentral. It includes the following fixes.
IIDR 11.4.0.0-5039 for all LUW engines
JR58448 REQUESTED TO REMOVE A UOW THAT WAS NOT THE ACTIVE UOW
IIDR 11.4.0.0-5039 for Db2 LUW
JR58500 THE SUBSCRIPTION FAILED BECAUSE THE CONFLICT HAPPENED BUT CDC CAN NOT RESOLVE IT.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5036 for all LUW engines
IIDR 11.4.0.0-5036 for all LUW engines is available on FixCentral. It includes the following fixes.
IIDR 11.4.0.0-5036 for Microsoft SqlServer
JR58579 LOG DEPENDENCY STOPS MOVING AND SEEING OCCASIONAL DATA LOSS.
IIDR 11.4.0.0-5035 for Oracle
JR58592 REPLICATION ENDS ON EXCEPTION 'THERE IS AN INCONSISTENCY IN THE SEQUENCE OF ORACLE REDO LOGS'
IIDR 11.4.0.0-5034 for Oracle
JR58327 RESTART POSITION IS NOT CHANGED AFTER REFRESH
JR58464 SUBSCRIPTIONS IN ARCHIVED_LOG_ONLY MODE NOT FAILING WHEN REQUIRED ARCHIVE LOGS DO NOT EXIST.
JR58591 TABLE HISTORY CLEANUP DOES NOT INDICATE WHEN CLEANUP IS RUNNING OR HOW MANY ROWS IT DELETED
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5033 for all LUW Engines
IIDR 11.4.0.0-5033 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.0-5033 includes the following items.
IIDR 11.4.0.0-5033 for Oracle
JR57663 INTERVAL PARTITION SUPPORT
IIDR 11.4.0.0-5032 for FlexRep
* Added support for EDB Postgres 9.6
IIDR 11.4.0.0-5032 for Microsoft SqlServer
* Added support for GEOMETRY and GEOGRAPHY datatypes
IIDR 11.4.0.0-5032 for Oracle
* Added support for Oracle 12Cr2
JR58209 CDC CAN SKIP CERTAIN ARCHIVE LOGS IF THOSE LOGS WERE CREATED MUCH LATER THAN OTHER ARCHIVED LOGS WITH LATER SEQUENCE
JR58247 IIDR ORACLE AGENT FAILS TO IDENTIFY RESTORED ARCHIVE LOGS.
IIDR 11.4.0.0-5031 for Kafka
* Added support for using a broker list in place of a ZooKeeper server connection
IIDR 11.4.0.0-5031 for Oracle
JR58339 EVENT LOG FLOODED WITH XA TRANSACTION MESSAGE
* Improved dmsupportinfo to collect information around Oracle XA transaction and DTP service
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5029 for all LUW engines
IIDR 11.4.0.0-5029 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5029 for Netezza
* IDAA performance enhancement
* JR57889 NOTIFICATIONS ARE NOT ISSUED WHEN THE LATENCY THRESHOLD IS CROSSED ON NETEZZA.
IIDR 11.4.0.0-5029 for Oracle
* JR58342 IIDR CDC METADATA SIZE IS INCREASING IN SIZE WHEN NEW PARTITIONS ARE ADDED.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5025 for all LUW engines
IIDR 11.4.0.0-5025 for all LUW engines is available on FixCentral.
JR58009 MISSING ROWS AND DATA MISMATCH AS A RESULT OF TRANSACTION ROLLBACK
JR58086 CDC ISSUES JAVA.LANG.NULLPOINTEREXCEPTION WHEN CDC TRIES TO UPDATE AN LOB VALUE AND THE CONFLICT CONDITION IS HIT.
IIDR 11.4.0.0-5025 for Hadoop (DataStage)
JR58033 HADOOP REPLICATION ENDS ON A BUFFEROVERFLOWEXCEPTION WHEN REPLICATING LOBS
IIDR 11.4.0.0-5025 for Oracle
JR58068 ORACLE INTERVAL PARTITIONING WITHOUT RULE BASED MAPPING ISSUE
IIDR 11.4.0.0-5025 for Microsoft SqlServer
JR58226 ALWAYS ON AVAILABILITY GROUP ERROR: CANNOT SAVE CHANGES: THE QUERY SELECT NAME FROM SYS.AVAILABILITY_GROUPS
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5024 for all LUW Engines
IIDR 11.4.0.0-5024 for all LUW Engines is available on FixCentral
JR58069 TABLE MAPPING FAILS WITH CHC9696E ERROR
IIDR 11.4.0.0-5024 for Oracle
JR58034 SUBSCRIPTION SHOULD NOT FAIL WHEN ONE OF THE RAC NODES IS DOWN
JR58054 CDC IS REPLICATING COLUMN DEFAULT VALUE FOR NON-NULLABLE COLUMN WHEN THIS COLUMN IS NOT CHANGED AS A PART OF UPDATE
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5023 for all LUW Engines
IIDR 11.4.0.0-5023 for all LUW Engines is available on FixCentral.
JR58020 DATABASE CONNECTIONS LEAK WHEN REPLICATION ENDS ON ABORT
IIDR 11.4.0.0-5022 for all LUW Engines
IIDR 11.4.0.0-5022 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.0-5022 for Oracle
* JR57643 HISTORY MAINTENANCE WHEN PROCESSING DDL CAN BE SLOW AND REDUCE CONCURRENCY BETWEEN SUBSCRIPTIONS
* JR57858 APPLY FAILS WITH ORA-12899 ON A COLUMN ADDED WITH ALTER TABLE .. ADD COLUMN ( ... NOT NULL DEFAULT XXX )
IIDR 11.4.0.0-5022 for DB2 LUW
* Add support for BOOLEAN datatype
* JR57340 UNABLE TO UPGRADE TO IIDR 11.3.3.3 IF 44 AND ABOVE DUE TO BOOKMARK FORMAT CHANGES.
IIDR 11.4.0.0-5021 for all LUW engines
IIDR 11.4.0.0-5021 for all LUW engines is available on FixCentral.
* Updated JVM.
IIDR 11.4.0.0-5020 for all LUW Engines
IIDR 11.4.0.0-5020 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5020 for DataStage (Cloudant)
JR57846 REPLICATION ENDS ON CLOUDANT WITH JAVA.NET.SOCKETEXCEPTION 'A SYSTEM CALL RECEIVED A PARAMETER THAT IS NOT VALID'
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5019 for all LUW engines
IIDR 11.4.0.0-5019 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5019 for Oracle
JR57900 POSSIBLE DATA CORRUPTION OR NAN EXCEPTION SEEN IN TRACES WHEN SAME SOURCE TABLE MIRRORED TO DIFFERENT TARGET DATASTORES.
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5017 for all LUW engines
IIDR 11.4.0.0-5017 for all LUW Engines is available on FixCentral
IIDR 11.4.0.0-5017 for Oracle
JR57440 EXCEPTION AT CONTINUE READING ERROR 'ROW ALREADY EXIST IN INDEX TS_ORACLE_ARCHIVES_PK ON TABLE TS_ORACLE_ARCHIVES'
JR57469 REPLICATION STOPS WITH ARRAYINDEXOUTOFBOUNDS EXCEPTION WHEN PARSING OVERFLOW RECORD FOR A TABLE THAT HAS LOB COLUMNS.
JR57587 TABLE NAME WITH TRAILING SPACES CANNOT BE FOUND IN DATABASE
JR57642 HISTORY CLEANUP IS NOT DONE IF SHARED SCRAPE IS DISABLED
JR57710 CDC FAILS TO READ THE ARCHIVED LOG IN THE PHYSICAL STANDBY MODE.
JR57798 EXCEPTION 'OPCODE T IS NOT MAPPED TO A DATADEFINITIONOPERATION TYPE' WHEN TRUNCATING ORACLE TABLE
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5016 for all LUW engines
IIDR 11.4.0.0-5016 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.0-5016 for DataStage (Cloudant, Hadoop, Flat Files)
JR57726 CDC FOR CLOUDANT /HADOOP DOESN'T RETRY ON SOCKETTIMEOUTEXCEPTION
IIDR 11.4.0.0-5012 for all LUW Engines
IIDR 11.4.0.0-5012 for all LUW Engines is available on FixCentral.
JR57644 WHEN A BOOKMARK QUERY DOES NOT RETURN, IT CAN CAUSE A SUBSCRIPTION TO HANG AND DMSHUTDOWN TO HANG
IIDR 11.4.0.0-5012 for Netezza
JR57030 CDC NETEZZA RUNS OUT OF MEMORY WHEN NETEZZA LOAD PROCESS HANGS OR TAKING VERY LONG TIME
IIDR 11.4.0.0-5012 for Oracle
JR57347 INCORRECT MESSAGE WHEN SORT BUFFER IS FULL
JR57477 DMSHOWLOGDEPENDENCY COMMAND RETURNS 'NULL' IN CASE OF LOG SHIPPING WITH DATAGUARD SETUP
JR57574 CDC ENCOUNTERED ARRAYINDEXOUTOFBOUNDS EXCEPTION WHILE REPLICATING
IIDR 11.4.0.0-5011 for all LUW Engines
IIDR 11.4.0.0-5011 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.0-5011 for DataStage (FlatFile, Hadoop and Cloudant)
JR57602 CDC DOES NOT INCLUDE CLOUDANT CHILD ENTRIES IN PARENT DOCUMENT
IIDR 11.4.0.0-5001 for Microsoft SqlServer
JR57585 CANNOT START IIDR INSTANCE WITH PRIVATE PARAMETERS CONFIGURED DUE TO EXCEPTION LOADING POINTBASE PROPERTIES
The builds can be found on FixCentral using this link:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.4&platform=All&function=all&source=fc
IIDR 11.4.0.0-5010 for all LUW engines
IIDR 11.4.0.0-5010 for all LUW engines is available on FixCentral.
JR56937 &TIMSTAMP VALUE INVALID FOR MD, MR AND JM ENTRY TYPES
IIDR 11.4.0.0-5010 for DB2 LUW
JR57107 DIFFERENTIAL REFRESH FAILS WHEN CHAR COLUMN IS PART OF THE COMPOSITE KEY
IIDR 11.4.0.0-5010 for Oracle
JR56917 'UNEXPECTED PARSING ERROR FOR TABLE' WHEN CDC WAS TRYING TO PARSE AN UPDATE OPERATION CAUSING SUBSCRIPTION TO ABORT.
JR57438 DMSHOWLOGDEPENDENCY IS THROWING EXCEPTION WITH -L OPTION
JR57440 EXCEPTION AT CONTINUE READING ERROR 'ROW ALREADY EXIST IN INDEX TS_ORACLE_ARCHIVES_PK ON TABLE TS_ORACLE_ARCHIVES'
JR57452 COMMITS ARE FILLING UP ASM AUDIT TRACES BECAUSE OF DEFAULT AUTOCOMMIT SETTING ON ORACLE EXADATA.
JR57581 A NECESSITY EXCEPTION 'REPORT_POSITION_ID IS BEFORE BOOKMARK' MAY END REPLICATION IN AN ORACLE RAC WITH AN INACTIVE NODE.
The builds can be found on FixCentral using this link:
IIDR 11.4.0.0-5008 for all LUW Engines
IIDR 11.4.0.0-5008 for all LUW Engines is available on FixCentral.
IIDR 11.4.0.0-5008 for all LUW Engines
JR57396 AFTER INSTALLING IIDR 11.4 WITH CDD OFFERING TYPE, DMCONFIGURETS FAILS WITH 'NO ILMT MARKER FILE FOUND'
IIDR 11.4.0.0-5008 for Oracle
JR56720 UPDATE IS FAILING WITH ERROR ORA-01407 WHEN COLUMN IS DEFINED AS NOT NULL WITH DATABASE DEFAULT VALUE
Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc
IIDR 11.4.0.0-5007 for all LUW engines
IIDR 11.4.0.0-5007 for all LUW Engines is available.
IIDR 11.4.0.0-5007 for all LUW Engines
JR57266 TAKING A TRANSACTION QUEUE SNAPSHOT FAILS WITH 'EXCEPTION CREATING THE TABLES IN THE TRANSACTION QUEUE DB'
IIDR 11.4.0.0-5007 for Oracle
JR57286 IIDR NOT RELEASING TEMPORARY LOB FILES
IIDR 11.4.0.0.-5007 for Microsoft SqlServer
Improved transaction log processing.
IIDR 11.4.0.0-5005 for all LUW engines
IIDR 11.4.0.0-5005 for all LUW engines is available on FixCentral
IIDR 11.4.0.0-5005 for Netezza
JR57240 ADD ABILITY TO CONTROL FREQUENCY OF BOOKMARK TABLE UPDATE ON REPORT POSITION MESSAGE.
IIDR 11.4.0.0-5004 for all LUW engines
IIDR 11.4.0.0-5004 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5004 for Oracle
JR57225 PRIVATE SCRAPER TXN QUEUES CANNOT BE REUSED BECAUSE LAST COMMITTED TXN IS EMPTY AND SO IS FILTERED OUT
JR57239 LATENCY RESULTS FROM ORACLE LOG PARSER INEFFICIENTLY MATCHING TRANSACTION LOG IDS
IIDR 11.4.0.0-5004 for FlexRep
REFRESH WHILE ACTIVE WITH FLEXREP RETURNS DUPLICATE ENTRY ERRORS
Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc
IIDR 11.4.0.0-5003 for all LUW engines is available on FixCentral
IIDR 11.4.0.0-5003 for all LUW engines is available on FixCentral.
IIDR 11.4.0.0-5003 for Oracle
* JR57120 DMSHOWLOGDEPENDENCY CAN RETURN A NULL POINTER EXCEPTION
* JR57121 DMSHOWLOGDEPENDENCY DOES NOT RETURN THE FULL LIST OF REQUIRED LOGS
* JR57125 DMSHOWLOGDEPENDENCY COMMAND CAN RETURN COMPLETED LOGS IN THE REQUIRED LOG LIST AS NOT AVAILABLE, MISSING
* JR57162 IIDR IS NOT ABLE TO GET NEXT ONLINE LOG FILE TO READ WHEN PRODUCT IS CONFIGURED TO READ FROM ORACLE RAC SYSTEM.
* JR57167 IIDR FAILS TO START, WITH INVALID PARAMETER BINDING ERROR.
IIDR 11.4.0.0-5003 for Netezza
* dmreassigntable table command added for CDC Netezza
Here is the link to the Fix Central page:
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm%7EInformation%2BManagement&product=ibm/Information+Management/IBM+InfoSphere+Data+Replication&release=11.3.3&platform=All&function=all&source=fc
IIDR 11.4.0.0-5001 for all LUW engines is available.
IIDR 11.4.0.0-5001 (GA version) contains all fixes up to and including 11.3.3.3-56. In addition, it contains the following fix.
IIDR 11.4.0.0-5001 for Oracle
* JR57085 CDC IS NOT PROCESSING ANY FILE IN MANUAL LOG SHIPPING WHEN FILE IS DELETED FROM ORIGINAL LOCATION
Related Information
Was this topic helpful?
Document Information
Modified date:
04 June 2024
UID
ibm11110477