IBM Db2 LUW Agent for Gluesync: Key Features

Gluesync on IBM Db2 for LUW uses the GDC (Gluesync Data Capture) feature to let the magic happen under the hood, more specifically Gluesync adopts an optimized triggers structure to catch events generated by operations that hit fields in your source DB2 LUW database.

Triggers on GDC are based on a per-transaction logic and only track changed row IDs, storing data on a table called Action logs table where all changed row IDs are stored and their data type is maintained unaltered.

This technique is also known as change tracking pattern. This is the opposite of change data capture which does not require a copy of all the data present in all the columns involved in a commit, this ensures performance gain and less footprint per transaction on your source database since no data transformation or manipulation is being required by our design.

Works starting from IBM i series version 11.5 and above.

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.