You can use PowerExchange in conjunction with PowerCenter to replicate change data from multiple DB2 for

i5/OS

sources to multiple targets of different types in a single session.

The following figure shows a simple CDC configuration that uses real-time extraction mode to access change data directly from local DB2 journal receivers without PowerExchange Condense:

In this real-time configuration, PowerExchange CDC uses the CAPXRT access method to capture change data from DB2 for i5/OS journal receivers. The UOW Cleanser reconstructs intermingled changes read from the change stream into complete UOWs in chronological order based on end time.

When an extraction request runs, PowerCenter connects to the PowerExchange Call Level Interface (SCLI) to contact the PowerExchange Listener. The change data is passed to the SCLI and then to the PWXPC CDC Real Time reader. In this manner, the PowerCenter extraction session pulls the change data that PowerExchange captured. After the PWXPC reader reads the change data, PowerCenter uses the mapping and workflow that you create to transform the data and load it to the target. With this configuration, you can replicate change data from multiple sources in the same database to multiple target tables in a single extraction process.