Skip to main content

Db2 for z/OS CDC architecture overview

Striim provides change data capture (CDC) support for IBM Db2 for z/OS through its integration with Rocket Software’s Rocket Data Replication Software (RDRS). RDRS captures committed DML operations from Db2 for z/OS and streams them in Avro-serialized format to a Kafka topic for downstream processing.

read_from_db2zos_cdc.png

As shown in the diagram above, RDRS captures the data changes from the source Db2 server, converts the source transaction to wire format, serializes it into binary as an Apache Avro message, and publishes it to an Apache Kafka topic in conjunction with a Confluent Schema Registry. Striim Connect retrieves relevant messages from the Kafka topic and uses the Avro schemas from the Schema Registry to deserialize them.

RDRS also utilizes either a PostgreSQL or Oracle database as a repository for metadata about input and output objects, as well as for configuring the replication workflows and their components. This may be the same PostgreSQL or Oracle database used by Striim for its metadata repository. (Derby is not supported as an RDRS metadata repository host.)