Skip to main content

Db2 for z/OS CDC

For an introduction to reading from Db2 for z/OS, see Db2 for z/OS.

Striim supports change data capture (CDC) from Db2 for z/OS versions 12 and 13.

Reading CDC from Db2 for z/OS uses an external source component (see Db2 for z/OS initial setup) rather than a reader component. Consequently you must create your Db2 for z/OS CDC applications using the Flow Designer or TQL rather than a wizard. (You can create Db2 for z/OS initial load applications using wizards.)

Db2 for z/OS summary

Integrated resources / requirements

  • IBM Db2 Connect and ODBC driver to read from Db2

  • Rocket Data Replication Software (RDRS) to read from Db2 Connect and write to a Kafka-persisted stream in Striim (to be provided by Striim)

  • PostgreSQL or Oracle Database to host the RDRS metadata repository

  • Kafka instance to accept data from RDRS (internal Striim instance or external instance version 3.6 or later)

  • Confluent Schema Registry version 7.6.1 or later

Data supported

Tables, views, materialized query tables (materialized views)

Supported targets

All targets that support WAEvent input. This includes all database, data warehouse, and file system targets.

Security and authentication

SSL / TLS between Db2 and RDRS and between RDRS and Kafka

Operations / modes supported

Change data can be captured as far back as the active logs on the z/OS mainframe have not been cleared out.

Captures inserts, updates and deletes.

Schema management

Use Database Reader to create the initial schema.Database Reader

Schema evolution must be handled manually. See Handling planned DDL changes.

Resilience / recovery

Supports recovery with exactly once processing. See Recovering applications.

Programmability

  • Striim TQL

  • Striim Flow Designer

Metrics and auditing

  • Key external source metrics are available through Striim monitoring

Key considerations and limitations

  • Tables without primary keys cannot be read.

  • Due to a limitation in RDRS, Inserts and updates larger than 1 MB cannot be captured.

  • Each RDRS pipeline requires a separate Striim application. Each Striim application can read from only a single RDRS pipeline.

  • Bidirectional replication is not supported.