Db2 for z/OS
Db2 for z/OS is a relational database management system that runs on the IBM® zSystems™ platform.
You can read from Db2 for z/OS as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from Db2 for z/OS in two phases—initial load, followed by continuous replication—as described in Building pipelines from Db2 for z/OS.
Note
Continuous real-time replication using Striim Connect is not available in Striim Developer, only in Striim Cloud and Striim Platform.
Db2 for z/OS feature summary
Feature | Initial load with Database Reader | Continuous real-time replication using Striim Connect | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|
Supported versions and services | |||
Db2 for z/OS versions 12 and 13 | ✔ | ✔ | ✔ |
Integrated ressources / requirements | |||
IBM Db2 Connect and ODBC driver to read from Db2 | IBM Db2 Connect and ODBC driver to read from Db2 Striim Agent for Db2 for z/OS 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 Striim Agent for Db2 for z/OS metadata repository | IBM Db2 Connect drivers to read from Db2 | |
Security and governance | |||
connection profile | |||
Sherlock AI | |||
Sentinel AIK | |||
Operations | |||
initial load | ✓ | ||
initial schema creation |
| ||
schema evolution |
| ||
DML operations replicable in target | INSERT, UPDATE, DELETE | INSERT (UPDATE handled as INSERT, DELETE ignored) | |
Building applications / programmability | |||
automated pipelines | |||
other wizards | initial load only |
| initial load only |
Flow Designer | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ |
Runtime | |||
output stream event type | WAEvent | WAEvent | WAEvent |
recovery | ✓ | E1P | ✓ |
parallel threads | ✓ | ✓ | |
metrics & auditing | ✓ | ✓ | ✓ |