Release Notes for IDR 11.4 for Db2 for z/OS Remote Source

IDR 11.4.0.5-5726

Enhancements in IDR 11.4.0.5-5726 for CDC Replication Engine for Db2 for z/OS remote source

• CDC now supports a started task as an alternative to the stored procedure for reading the Db2 log.
• Effective January 2025, IDR CDC will no longer provide support for following operating system versions: RedHat Enterprise Linux (RHEL) 7; CentOS 7.x

IDR 11.4.0.5-5725

Enhancements in IDR 11.4.0.5-5725 for CDC Replication Engine for Db2 for z/OS remote source

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

Known Issues fixed in IDR 11.4.0.5-5725 for CDC Replication Engine for Db2 for z/OS remote source

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

IDR 11.4.0.5-5722

Known Issues fixed in IDR 11.4.0.5-5722 for CDC Replication Engine for Db2 for z/OS remote source

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

IDR 11.4.0.5-5721

Enhancements in IDR 11.4.0.5-5721 for CDC Replication Engine for Db2 for z/OS remote source

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

Known Issues fixed in IDR 11.4.0.5-5721 for CDC Replication Engine for 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-5719

Known Issues fixed in 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 for CDC Replication Engine for Db2 for z/OS remote source

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

IDR 11.4.0.5-5707

Known Issues fixed in 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 for CDC Replication Engine for Db2 for z/OS remote source

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

IDR 11.4.0.5-5703

Enhancements in IDR 11.4.0.5-5703 for CDC Replication Engine for Db2 for z/OS remote source

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

Bugs fixed in IDR 11.4.0.5-5703 for CDC Replication Engine for Db2 for z/OS remote source

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

IDR 11.4.0.5-5702

Enhancements in IDR 11.4.0.5-5702 for CDC Replication Engine for Db2 for z/OS remote source

• CDC now supports Db2 z/OS with PH53641
• Added ParallelizeByHash, ParallelizeByHashNetEffect, and ParallelizeByHashNetEffectConvertUpdates fast apply algorithms

Bugs fixed in 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
• Specifying the number of image builder threads via the NullMirrorOptimizer fast apply user exit causes subscription to stop

IDR 11.4.0.5-5700

Enhancements in IDR 11.4.0.5-5700 for CDC Replication Engine for 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
• Updated various open source libraries

IDR 11.4.0.5-5699

Bugs fixed in IDR 11.4.0.5-5699 for CDC Replication Engine for Db2 for z/OS remote source

• 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 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 for Db2 for z/OS remote source

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

Bug fixes in 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.4-5694

Enhancements in IDR 11.4.0.4-5694 for Db2 for z/OS remote source

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

Bug fixes in IDR 11.4.0.4-5694 for Db2 for z/OS remote source

• DT245994 Replication occasionally fails with IFI error E60865 after upgrading to build 5679 or newer

IDR 11.4.0.4-5686

Enhancements in 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
• Updated JVM to 8.0.8.6, java version "1.8.0_371"

IDR 11.4.0.4-5684

Enhancements in 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

Bug fixes in 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-5676

Enhancements in IDR 11.4.0.4-5676 for Db2 for z/OS remote source

• Added ParallelizeByTableNetEffect and ParallelizeByTableNetEffectConvertUpdates fast apply algorithms

IDR 11.4.0.4-5674

Enhancements in IDR 11.4.0.4-5674 for Db2 for z/OS remote source

• Updated JVMs to 8.0.8.0

APARs in IDR 11.4.0.4-5674 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5672

Enhancements in IDR 11.4.0.4-5672 for Db2 for z/OS remote source

• Added DDL Awareness for Alter Table Rename Column
• New derived expression %ORDERTAB(), to track per table record sequence number, is now supported on target agent.
• Updated JVMs to 8.0.7.20

APARs in IDR 11.4.0.4-5672 for Db2 for z/OS remote source

• JR65241 CDC FOR DB2 FOR Z/OS REMOTE SOURCE COULD HIT ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN QUERYING GRAPHIC COLUMN TYPE

Bug fixes in IDR 11.4.0.4-5672 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5670

Enhancements in IDR 11.4.0.4-5670 for Db2 for z/OS remote source

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

APARs in IDR 11.4.0.4-5670 for Db2 for z/OS remote source

• JR65110 REFRESH NUMBER OF ROWS SUCCESSFULLY APPLIED CAN BE NEGATIVE
• JR65235 ROW FILTER &ENTTYP='UB' NEVER MATCHES, AND &ENTTYP='UP' MATCHES BOTH UB AND UP ROWS

IDR 11.4.0.4-5666

Enhancements in IDR 11.4.0.4-5666 for Db2 for z/OS remote source

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

Bug fixes in IDR 11.4.0.4-5666 for 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
• TCP/IP connections are closed prematurely when encrypted with TLS.
• "PKIX path building failed" error while retrieving schemas from the database over TLS, even though the database's root CA certificate was configured in the encryption profile's trust store.

IDR 11.4.0.4-5661

Enhancements in IDR 11.4.0.4-5661 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5659

Enhancements in IDR 11.4.0.4-5659 for Db2 for z/OS remote source

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

APARs in IDR 11.4.0.4-5659 for 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-5656

Enhancements in IDR 11.4.0.4-5656 for Db2 for z/OS remote source

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

APARs in IDR 11.4.0.4-5656 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5652

Enhancements in IDR 11.4.0.4-5652 for Db2 for z/OS remote source

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

APARs in IDR 11.4.0.4-5652 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5644

Enhancements in 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.

APARs in 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-5643

Enhancements in IDR 11.4.0.4-5643 for Db2 for z/OS remote source

• Support storing replication engine database credentials in an external secret store
• Updated JVMs to 8.0.7.10

IDR 11.4.0.4-5629

Enhancements in IDR 11.4.0.4-5629 for 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

APARs in IDR 11.4.0.4-5629 for Db2 for z/OS remote source

• JR64572 NO WARNING EVENT WHEN CHARACTER DATA IS TRUNCATED

IDR 11.4.0.4-5627

Enhancements in IDR 11.4.0.4-5627 for Db2 for z/OS remote source

• Parallel Apply is now allowed with Adaptive Apply

APARs in IDR 11.4.0.4-5627 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5625

Enhancements in IDR 11.4.0.4-5625 for Db2 for z/OS remote source

• The JDBC driver has now been updated from version 5.1.4.000298 to 5.1.4.000336
• InstallAnywhere VM pack for CDC engine installer updated to Java 8.0.7.0
• IDR added a new command line utility "dmimportuserconfiguration" to help automate creation of multiple product instances with user configured values

APARs in IDR 11.4.0.4-5625 for Db2 for z/OS remote source

• JR64573 LOG READING IS SLOW DUE TO RETRYING TO READ LOG RECORDS WITH HARD DECOMPRESSION ERRORS
• JR64618 DMTS64 PROCESS IS TAKING A LONGER TIME TO START

Bug fixes in 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
• Fixed possible "duplicate key" or "row does not exist" error when replication key is being updated with ParallelizeSingleTableByHash fast apply algorithm

IDR 11.4.0.4-5622

Enhancements in IDR 11.4.0.4-5622 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5618

APARs in IDR 11.4.0.4-5618 for Db2 for z/OS remote source

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

Enhancements in IDR 11.4.0.4-5616 for Db2 for z/OS remote source

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

APARs in IDR 11.4.0.4-5611 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5609

Enhancements in IDR 11.4.0.4-5609 for Db2 for z/OS remote source

• Shared Scrape is now enabled by default for Db2 z/OS Remote

APARs in 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-5607

Bug fixes in IDR 11.4.0.4-5607 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5603

Enhancements in IDR 11.4.0.4-5603 for Db2 for z/OS remote source

• IDR now supports DDL resiliency by handling DDL ADD COLUMN, ALTER COLUMN, DROP COLUMN automatically

APARs in IDR 11.4.0.4-5603 for Db2 for z/OS remote source

• JR64071 IDR CDC FAILS WITH STATEMENT CLOSED ERROR WHILE RUNNING ADDITIONAL SQL STATEMENTS DURING REFRESH.

Bug fixes in IDR 11.4.0.4-5603 for Db2 for z/OS remote source

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

IDR 11.4.0.4-5599

Enhancements in IDR 11.4.0.4-5599 for Db2 for z/OS remote source

• Updated the Java Virtual Machine to IBM 8.0.6.30

APARs in IDR 11.4.0.4-5599 for Db2 for z/OS remote source

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

Bug fixes in IDR 11.4.0.4-5599 for Db2 for z/OS remote source

• 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 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 for Db2 for z/OS remote source

• Fixed NecessityException in ChangeLogBlock on instance start up

IDR 11.4.0.3-5594

APARs in IDR 11.4.0.3-5594 for Db2 for z/OS remote source

• 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

Bug fixes in 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-5590

APARs in 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

Bug fixes in 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-5587

Enhancements in 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

Bug fixes in 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-5582

Enhancements in 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-5576

Enhancements in 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
• The dmsupportinfo command line utility now dumps and collects configuration metadata in a text format

APARs in IDR 11.4.0.3-5576 for Db2 for z/OS remote source

• JR62920 EXCESSIVE DIAGNOSTIC PROBES FOR TRUNCATE OF CLOB EVENTS

Bug fixes in IDR 11.4.0.3-5576 for Db2 for z/OS remote source

• 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 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 for Db2 for z/OS remote source

• Add a time limit to the stored procedure call and fail if timeout is exceeded
• EVENT THAT ALERTS USER THAT IDR HAS DETECTED A DDL NOW INCLUDES THE DDL TEXT IF LOGGING OF DDL STATEMENTS IS ENABLED

APARs in IDR 11.4.0.3-5572 for Db2 for z/OS remote source

• JR62909 INCORRECT SAMPLE CONTENT WHEN ISSUING "DMEXPORTCONFIGURATION -?"
• JR62934 DMTS64 NOT RELEASING IX (EXCLUSIVE) LOCK ON SYSTABLES AFTER MAKING DATABASEMETADATA CALLS

Bug fixes in IDR 11.4.0.3-5572 for Db2 for z/OS remote source

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

IDR 11.4.0.3-5570

Enhancements in IDR 11.4.0.3-5570 for Db2 for z/OS remote source

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

APARs in IDR 11.4.0.3-5570 for Db2 for z/OS remote source

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

Bug fixes in IDR 11.4.0.3-5570 for Db2 for z/OS remote source

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

IDR 11.4.0.3-5567

APARs in IDR 11.4.0.3-5567 for Db2 for z/OS remote source

• JR62737 CDC ERROR 9506 OCCURS AFTER A DDL EVEN WHEN ALL DDL PROCEDURES ARE FOLLOWED

Bug fixes in IDR 11.4.0.3-5567 for Db2 for z/OS remote source

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

IDR 11.4.0.3-5566

Enhancements in IDR 11.4.0.3-5566 for Db2 for z/OS remote source

• Java Runtime Environment updated from IBM Java 8.0.6.0 to 8.0.6.10. Fix notes can be found at https://developer.ibm.com/javasdk/support/fixes/sdk8/

APARs in IDR 11.4.0.3-5566 for Db2 for z/OS remote source

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

IDR 11.4.0.2-5563

APARs in IDR 11.4.0.2-5563 for Db2 for z/OS remote source

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

IDR 11.4.0.2-5560

Enhancements in IDR 11.4.0.2-5560 for Db2 for z/OS remote source

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

APARs in 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

Bug fixes in 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 will no longer log excessive tracing of NonTransientConnectionException by avoiding rolling back a transaction on a database connection that has auto-commit enabled.
• dmconfigurets no longer creates two trace files when run in the command line mode.

IDR 11.4.0.2-5544

Enhancements in IDR 11.4.0.2-5544 for Db2 for z/OS remote source

• dmsupportinfo no longer collects duplicate information in the "dir.txt" support assistant file when an instance folder is inside the product installation directory.

APARs in IDR 11.4.0.2-5544 for Db2 for z/OS remote source

• JR62126 IMPROVED IDR COMMAND LINE UTILITIES PERFORMANCE BY OPTIMIZING ACCESS TO CDC SECRET STORE WHEN ENGINE-TO-ENGINE ENCRYPTION IS DISABLED, ENABLED OR REQUIRED.
• JR62158 SCHEDULED END BY TIME SOMETIMES DOESN'T WORK WHEN DB IS 100% IDLE, SHARED SCRAPE IS USED AND SUBSCRIPTION FINDS NEW OPERATIONS IN STAGING STORE AT STARTUP.

Bug fixes in IDR 11.4.0.2-5544 for 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.
• 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 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 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 now closes some idle database connections and re-opens them as needed. The global_database_connection_idle_timeout_seconds system parameter controls how long to keep idle database connections open. Closing idle database connections before firewalls close them prevents subscriptions from stopping due to broken database connections.

APARs in IDR 11.4.0.2-5528 for 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
• JR61841 ERROR REFRESHING A TABLE WITH A LONG COLUMN COMMENT: "AN UNCAUGHT EXCEPTION HAS OCCURRED"

Bug fixes in IDR 11.4.0.2-5528 for Db2 for z/OS remote source

• IDR now detects the correct Db2 12 version when ZPARM DDF_COMPATIBILITY includes IDNTFY_V12_PRIOR_VER.
• IDR automatically recovers an erroneous metadata state that could cause lead to "An error has occurred. Possible recovery steps: Please try again. If the error persists, if possible restart the IBM Data Replication instance and try again. Internal error information: Agent Message 'Message3036' Exception text 'null'"
• Improved reliability when global_subscription_level_connection_keep_alive_seconds is set to a non-zero value.
• IDR now uses a different method to manipulate metadata table TABLE_NAMES_IDENTITY that is expected to prevent metadata corruption involving this table. This corruption could lead to the inability to use a table mapping or even delete it.
• Addressed intermittent EOFException and SocketException when running command line utilities under stress.
• Addressed intermittent EOFException reported by Agent Reader thread when using command line utilities.

IDR 11.4.0.2-5522

Enhancements in IDR 11.4.0.2-5522 for 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 issues an improved error message when dmconfigurets is run with non-Administrator privileges in Windows Server 2016

APARs in IDR 11.4.0.2-5522 for Db2 for z/OS remote source

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

Bug fixes in 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."

IDR 11.4.0.2-5512

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

APARs in IDR 11.4.0.2-5512 for Db2 for z/OS remote source

• JR61637 CDC STILL TAKES VALUES IN BYTES AFTER CHANGING SYSTEM PARAMETER USEREXIT_MAX_LOB_SIZE_KB UNLESS THE INSTANCE IS RESTARTED

Bug fixes in IDR 11.4.0.2-5512 for 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.
• Trace can now be collected reliably using support assistant in concurrent invocations.
• Addressed differential refresh failing when order of columns in primary key differs from order returned by JDBC

IDR 11.4.0.2-5507

Enhancements in IDR 11.4.0.2-5507 for Db2 for z/OS remote source

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

IDR 11.4.0.2-5506

Enhancements in IDR 11.4.0.2-5506 for 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 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-5503

Enhancements in 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.
• Prior product libraries found in /lib are deleted when upgrading product binaries before new libraries are dropped on disk. All jar files with names similar to those installed with the product will be deleted.
• IIDR now supports the option of requiring TLS encryption for all connections from Access Server and other datastores.

APARs in IDR 11.4.0.2-5503 for Db2 for z/OS remote source

• JR61380 "ARITHMETICEXCEPTION DIVIDE BY 0" IS THROWN WHEN ONLY DERIVED COLUMN ARE SET FOR REPLICATION

Bug fixes in IDR 11.4.0.2-5503 for Db2 for z/OS remote source

• The GUI configuration tool now preserves the user prefix when it prompts for the database password.