V4.1.x - V4.1.38 - connect_cdc_sqdata - Latest

Connect CDC (SQData) Release Notes
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Release Notes
Copyright
2026
First publish date
2018
ft:lastEdition
2026-03-10
ft:lastPublication
2026-03-10T11:41:18.328000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC
Release Component Description
4.1.38 Apply Engine (SQDENG)
  • Fix SEGFAULT when Db2z VARBINARY column source is replicated automatically to JSON/AVRO schema.

  • Correct handling of OPTIONS CDCOP that only occurs when the two step SQDPARSE and SQDATA execution method is used and the target was AVRO format.
4.1.37 Db2/z Log Capture (SQDDB2C)
  • Display the memory cache limit on DB2z capture display command.
  • Add command line parameter to specify IFI return area buffer size for DB2z capture.
  • Release DB2z IFI Return Area ECSA storage on abnormal termination (ABTERM).
  • Include the complete UOW/URID field in the UTS CDC record header.
  • Replace the begin UR time with the commit time stamp STCK in the UTS CDC record header.
zOS CDCzLog Publisher (SQDZLOGC)
  • Increase logstream cleaning frequency from 5 seconds to 1 second.
  • Correct issue with the excessive commit window time to avoid long delays when commit record is returned in the same call where end-of-logstream has been reached.
Apply Engine (SQDENG) Issue new runtime error message SQDE017E if the SETURL function is used with a generic URL.
4.1.36 Db2/z Log Capture (SQDDB2C)
  • Added support for user-defined DISTINCT TYPE data type. Captured data will be treated as the designated existing built-in Db2/z data type. This functionality requires an additional Db2/z GRANT for SYSIBM.SYSDATATYPES.
    Note: This Release requires an additional Db2/z GRANT in order to execute Db2/z Log Capture.
  • Retry eligible IFI decompression errors only if table is specified as Active for Capture.
IMS TM Exit Capture
  • Remove DLIBATCH support from IMS exit capture.
Apply Engine (SQDENG)
  • Correct Oracle Cursor processing when looping on SQL Fetch by rebinding Oracle cursor SQLDA.
  • Three called Functions added: BLENGTH, BSEARCH, BRECLEN.
Apply Engine (SQDENG) and IMS Unload Utility (SQDIMSU) Increase output buffer size for IMS INQY ENVIRON DLI calls to IBM's recommended minimum of 512K.
4.1.35 Db2/z Log Capture (SQDDB2C)
  • Fix contention in DB2/z capture when VFILE is full.
  • Fix double free ASSERT in DB2/z capture on stop/start.
  • Map obsolete DB2/z LONGVAR column type as VARCHAR
Apply Engine (SQDENG) Support SKIP statements in COBOL copybook parser
Apply and Replicator Engine (SQDRPL): Linux ONLY
  • Support for gnutls version 3.6 required by RHEL 8.
  • Fix loading of libcurl DLL to support recent versions.
4.1.34 Apply Engine (SQDENG) Tolerate Db2 DECFLOAT columns when parsing Apply Engine script. The content of DECFLOAT columns will however be treated as zero for all targets.
Replicator Engine (SQDRPL) Db2 DECFLOAT column content treated as zero except for Db2 and AVRO (using AVRO bytes type) targets.
Oracle LogMiner Capture Fix excessively long wait for Oracle capture to resume processing the Oracle log during periods of little or no Oracle database activity.
4.1.33 Db2/z Log Capture (SQDDB2C) Suppress VFILE fatal errors when cleaning up fully published transactions.
zOS ISPF Panels Fix error in ISPF Logstream Detail display when advanced current allocations (LS_ALLOCAHEAD keyword on DEFINE LOGSTREAM) is specified for the CDCzLog Publisher (SQDZLOGC) Logstreams used by the IMS and VSAM Capture.
Apply Engine (SQDENG) Add Kafka fatal error count to engine report for generic URLs.
Apply and Replicator Engines Fix AVRO encoding of 0 and -1 for logical decimal type fields.
4.1.32 Db2/z Log Capture (SQDDB2C) Add APPLCOMPAT(V12R1M500) option and comment regarding required function level to sample DB2/z package/plan bind. While it is required for V4.1 Db2/z Dynamic Refresh, it should be removed for lower Function levels.
IMS Log Capture (SQDIMSC) Fix S0C4 in IMS capture after zlog error.
IMS Log Capture (SQDIMSC) and CDCzLog Publisher (SQDZLOGC) Add System Logger reason code name to zlog error messages.
Apply Engine (SQDENG)
  • Support alternate SQDPARMI input DD for IMS Engines running under the Master.
  • Add Kafka fatal error count to engine report for non-generic URLs.
  • COBOL Parser changes to support three items allowed by the COBOL specifications:
    • Field names that start with a digit. However, since nothing is automatically substituted for JSON formatted targets, the REPLICATE Command will require source COBOL copybooks to be manually modified or a target description created with a valid name which is "manually populated in the Apply Engine script.
    • Group or elementary items without a name are treated as though the reserved word FILLER has been specified.
    • Lines containing blanks in columns 7-72.
Apply and Replicator Engines
  • Issue error message when ICU4C library libicuuc is not found or cannot be loaded on Linux.
  • Kafka target topic name improperly defaulted to underscores for IMS source CDC data instead of IMS DBDNAME when no other Topic name was specified.
4.1.31 Db2/z Log Capture (SQDDB2C) Fix unreported S0C4 on DB2/z table refresh request when table was not configured for capture
VSAM Log Capture Detect CICSVR VSAM batch capture commit for IAM files.
IMS Log Capture (SQDIMSC)
  • Prevent stale IMS log capture safe_restart that prevented capture from resuming on Start.
  • Terminate IMS log capture with message SQDI716E if start time is not in RECON.
Apply Engine (SQDENG) Fix segfault on Kafka AVRO format APPLY of VSAM CDC data.
4.1.30 Db2/z Log Capture (SQDDB2C) Improve diagnostic messages for VFILE_FATAL_ERROR.
zOS Installation Prevent duplicate PGMOBJ creation on z/OS installation. ALLOCDS and UNTERLIB JCL were modified because both were creating the PGMOBJ causing a JCL error.
4.1.29 Apply Engine (SQDENG) Support added to APPLY Command for custom Confluent AVRO schema format without CDC metadata.
Db2/z Log Capture (SQDDB2C) Fix corner case issue where source tablespace was not released on Pause of Db2/z Capture.
Db2/z, Db2/LUW and Oracle Log Capture Corrected CDCStore transient storage usage statistics display.
4.1.28 Apply Engine (SQDENG), IMS Unload Utility (SQDIMSU) The DBD parser now fully supports DBD application program metadata. Support in this case means tolerates their presence. This metadata is not used in anyway today by the Connect CDC (SQData) product.
4.1.27 Apply Engine (SQDENG) Terminate on Kafka ack error corner case.
Apply and Replicator Engines Azure Key Vault Kafka .ini file corrections.
4.1.26 Db2/z Log Capture (SQDDB2C) Correction to retry IFI Read for un-decompressed log records when the compression dictionary was unavailable to the IFI. A default retry count of 5 and retry interval of 5 seconds can be modified by two new SQDPARMS DD parameters:
  • --log-retry-count=<number of retrys>
  • --log-retry-interval=<seconds>
4.1.25 Db2/z Log Capture (SQDDB2C) Correction to Db2/z Dynamic Refresh which was failing on TIMESTAMP WITH TIME ZONE columns.
Apply (SQDENG) and Replicator (SQDRPL) Engines
  • Corrected AVRO encoding of Double and Single precision floating point numbers.
  • Updated support for Confluent cryptokafka to v7.
4.1.24 Db2/z Log Capture (SQDDB2C)
  • Dynamic Refresh requests made with SQDCONF utility now set RC=8 and reason DB2C_REFRESH_REQUEST_REJECTED when a refresh request fails because Db2/z capture is paused or stopped.
  • Correct Invalid Timezone error on Dynamic Refresh.
Apply (SQDENG) and Replicator (SQDRPL) Engines Correct message ID on "SQD1014I Refresh started" message that was incorrectly displayed as SQD1011I.
Apply Engine (SQDENG)
  • The Precision of Decimal source fields initialized by INVALID ALLNUM SETZERO were incorrect resulting in "ODBC SQL State: HY104 Invalid precision value" Error when target was SQL Server.
  • Resolve an empty cache lock race condition related to cache reuse that was corrected in V4.1.23 for the Replicator but not the Apply Engine.
4.1.23 Apply (SQDENG) and Replicator (SQDRPL) Engines
  • Correct issue with the length returned from CONVERT CCSID when converting UTF-16 to another code page.
  • Correct stalling issue when empty cache buffers had not been freed and large UOW's (unit-of-work) would not fit in a single cache buffer.
4.1.22 Replicator Engine Reduced TCP/IP soft keep alive from 3 minutes to 15 seconds.
4.1.21 Apply (SQDENG) and Replicator (SQDRPL) Engines Added version check for librdkafka library. They will Stop if an older, non-compatible version is detected.
Replicator Engine (SQDRPL) Improve trace diagnostic messages to identify possible race conditions when switching between UOW cache mode and serial mode. Serial mode is invoked for very large transactions that will not fit in the UOW cache buffers.
4.1.20 Apply (SQDENG) and Replicator (SQDRPL) Engines Added support for Azure key vault.
Apply Engine (SQDENG) Default the conversion of source code page to UTF-8 for special characters.
4.1.18 Apply (SQDENG) and Replicator (SQDRPL) Engines Correct deadlock issue that occurred when errors occurred while writing to Kafka.
4.1.17 Apply Engine (SQDENG) On IMS targets, use GHN vs GHNP for processing mass deletes to improve performance.
Replicator Engine (SQDRPL) Add TCP/IP soft keep-alive to avoid socket disconnection during periods of inactivity.
4.1.15 Apply Engine (SQDENG) Improve setup and cleanup for S3 targets.
4.1.14 IMS TM Exit Capture Add root segment key length support to IMS exit. No impact on older version Apply Engines.
Replicator Engine (SQDRPL) In Distributor mode, decompress root key (if compressed) prior to writing raw IMS CDC messages to Kafka.
4.1.13 Replicator Engine (SQDRPL) In Distributor mode, correct issue with default topic selection when there are no mappings in the configuration file.
4.1.12 Apply (SQDENG) and Replicator (SQDRPL) Engines Support the use of Confluent's proprietary cryptographic method of payload encryption for data at rest.
Replicator Engine (SQDRPL) Support streaming raw IMS CDC records to Kafka topics for high-volume transaction workloads for performance scaling.
Apply Engine (SQDENG) Add support for Kafka source Datastores to support reading Kafka topics containing raw IMS CDC records.
4.1.11 Apply (SQDENG) and Replicator (SQDRPL) Engines Support IMS DBD's containing extended SEGM ENCODING specification.
IMS TM Exit and Log Capture (SQDIMSC) Support IMS DBD's containing extended SEGM ENCODING specification.
Apply Engine (SQDENG) Correct issue with dummy messages (T_PIG) not being understood by the engine.
4.1.10 Db2/z Log Capture (SQDDB2C) Correct issue with compensation log records for single Db2/z subsystem captures.
4.1.8 Db2/z Log Capture (SQDDB2C) Correct sequence of key columns generated during metadata discovery phase.
Apply Engine (SQDENG) IMS Root Segment Keys lost when using REMAP corrected.
4.1.7 Db2/z Log Capture (SQDDB2C) Increase the size of the printed SELECT statement message used for REFRESH.
4.1.6 Db2/z Log Capture (SQDDB2C) Check for stop or display commands more frequently when processing large UOW's rather than waiting for Engines to complete processing of the UOW.
4.1.4 Db2/z Log Capture (SQDDB2C) Improve messages generated when processing REFRESH slices.
z/OS System Authorization Facility (SAF) capability has been added for utility programs SQDCONF and SQDUTIL These utilities can perform a number of functions ranging from Modification and Status Display of a Capture agent to the cleaning of a z/OS System LogStream. This enhancement provides for the optional restriction of specific commands using SAF and the customer's underlying security system (RACF, ACF2 or Top Secret) using classes and profiles. See the two Utility reference manuals for more details regarding z/OS Security Options under Operational Considerations.
4.1.3 Apply Engine (SQDENG) Lazy load MQSeries libraries only if MQSeries is to be used as a source or target datastore.
Apply (SQDENG) and Replicator (SQDRPL) Engines The International Components for Unicode (libicu) no longer ships with the product for Linux. The operating system specific library is now an installation prerequisite when required for Unicode (CCSID) conversion.
4.1.2 Db2/z Log Capture (SQDDB2C) Improve reporting and range selection support for REFRESH.
Apply (SQDENG) and Replicator (SQDRPL) Engines The libicu (International Components for Unicode) no longer ships with the product for AIX. The operating system specific library is now an installation prerequisite when required for Unicode conversion.
4.1.1 Db2/z Log Capture Introduce Dynamic Refresh capability for large tables. This enhancement replaces the existing table REFRESH functionality that only accommodated small tables.