IBM Db2 LUW CDC Agent for Gluesync: Key Features
Core principles
This agent establishes a connection to IBM Db2 for LUW via a built-in JDBC driver and provides Change Data Capture capabilities through a stored procedure-based approach combined with a CDC table infrastructure. This method enables capturing changes from Db2 LUW databases in real-time by leveraging native database features without requiring complex transaction log configurations.
Change data capture
This agent uses a stored procedure (GS_SP_LOGMINER) that polls the database at configurable intervals, reads change events from Db2’s internal structures, and writes captured changes to dedicated CDC tables within the GLUESYNC schema. This approach captures richer transaction metadata — including transaction IDs, timestamps, and operation types — compared to the Triggers-based agent.
Supported version
Gluesync supports IBM Db2 for LUW on both single-instance and partitioned database environments (including the Community Edition):
-
CDC Source (Stored Procedure & Native Log Reader): Requires IBM Db2 for LUW version 11.5.8.0 or higher (including Db2 12.1+).
-
Target & Snapshot Loads: Supported on IBM Db2 for LUW version 11.5 and higher via JDBC.
|
Minimum Version Requirement for CDC: 11.5.8.0+ IBM Db2 LUW versions prior to 11.5.8.0 (such as 11.5.0.0 through 11.5.7.0) contain a known defect in the Db2 engine ( IBM resolved this memory leak starting with Db2 LUW 11.5.8.0 (Fix Pack 8) and in Db2 12.1+. Consequently, Change Data Capture using |
Platform supported features
| Feature | Support | Notes |
|---|---|---|
Target role |
✅ |
Streams data into Db2 LUW via the bundled JDBC driver. |
Source role |
✅ |
Captures changes through stored procedure-based CDC. |
Snapshots |
✅ |
Full snapshot loads are supported prior to CDC. |
CDC |
✅ |
Stored procedure-based CDC writes changes into GLUESYNC CDC tables. Requires Db2 LUW 11.5.8.0+. |
CDC type |
Stored Procedure + CDC table |
GS_SP_LOGMINER stored procedure populates the CDC queue. |
User defined data types |
✅ |
Supports user defined data types. |
Bulk load |
❌ |
This agent does not currently support bulk loading. |
Database pooling |
✅ |
Supports connection pooling for efficient resource utilization across multiple pipelines. |
Source persisted internal cache |
N/A |
State tracking relies on the CDC table plus Core Hub metadata. |
Target persisted internal cache |
N/A |
Writes go straight to Db2 via JDBC; no extra caching. |
Driver / connector |
Built-in JDBC driver |
Gluesync embeds the vendor JDBC driver for Db2 LUW connectivity. |
Chains |
N/A |
Not yet supported. |
Truncate operation support (reading) |
❌ |
This agent does not currently support reading TRUNCATE operations. |
Truncate operation support (writing) |
✅ |
Target agent honors the Core Hub "TRUNCATE before snapshot" option. |
Change data capture
Works starting from IBM Db2 for LUW version 11.5.8.0 and above. A native shared library (libdb2.so) must be deployed on the Db2 server host before enabling CDC. See the setup guide for deployment instructions.
Q&A
I have got DB2 on an i series system, is it supported? IBM Power (AS/400) is supported and requires the usage of a specific Gluesync source connector for IBM Power that makes use of the AS400 built-in journal. To read more about this specific source connector you can follow this link.
I have got DB2 running on z/OS (aka mainframe) is it supported? This specific version has not yet been tested. If you would like to consider helping us with testing in this system please reach out to us by writing at hello@molo17.com.