Skip to main content

Creating a Db2 for z/OS CDC application

Note

Before you can create a Db2 for z/OS CDC application, you must perform all the steps in Db2 for z/OS initial setup.

Striim includes wizards for creating Db2 for z/OS initial load applications, but not for CDC applications since that requires creating a pipeline in Rocket Data Replication Software (RDRS).

To create a Db2 for z/OS CDC application:

  1. In the target, if they do not exist already, create the tables that Striim will write to. (Typically these tables will already have been created as part of the initial load.)

  2. Using TQL or the Flow Designer, create a Striim application as described in 9. Create and deploy the Striim application. You must do this first to create the Kafka-persisted stream (external source) to be specified in the RDRS configuration file.

  3. In Db2, if any tables to be captured do not have primary keys, add them. (RDRS cannot capture change data from tables without primary keys.) Note that the VARBINARY type is supported in composite primary keys only if it is the last column in the key.

  4. In Db2, enable capture changes for the tables to be read.

  5. Create an RDRS configuration file as described in 10. Populate the RDRS configuration file. Use the RBA_LRSN property to start CDC from the point where the initial load completed.

  6. Create and start the RDRS pipeline:

    setupRDRS_DB2zOS.sh -a create -s <db2 password> -p <path to configuration file>
setupRDRS_DB2zOS.sh -a start -f <path to configuration file>

  7. Start the Striim application.