The DB2 for z/OS ECCR captures the change data and sends it to the PowerExchange Logger for z/OS for logging. On a single DB2 subsystem or z/OS image, you can run multiple DB2 ECCRs, each connecting to a different DB2 subsystem. A single DB2 ECCR can connect to only one DB2 subsystem and communicate with only a single PowerExchange Logger instance.

In a DB2 data sharing environment, a single DB2 ECCR captures changes for all members of the data sharing group.

To capture change data, you must define a capture registration for each source table. In the capture registration, you can select a subset of columns for which to capture data. PowerExchange generates a corresponding extraction map.

If a source table contains columns in which you store data that is inconsistent with the column datatype, you can create a data map to manipulate that data with expressions. For example, if you store packed data in a CHAR column, you can create a data map to manipulate that data to prepare it for loading to a target. Then, merge the data map with an extraction map.