Ensure that archive logging is active for the database.

Create a PowerExchange capture catalog table in the database. The capture catalog table stores information about all tables in the source database, including column definitions and Db2 log positions.

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. Optionally, you can define an additional extraction map.

If a source table contains columns in which you store data in a format that is inconsistent with the column datatype, you can optionally 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 and prepare that data for loading to a target. You must merge the data map with the extraction map for the source table during capture registration creation.

If you want to use the PowerExchange Logger for Linux, UNIX, and Windows to capture change data and write it to PowerExchange Logger log files, configure the PowerExchange Logger. The change data is then extracted from the PowerExchange Logger log files. Benefits of the PowerExchange Logger include fewer database accesses, faster CDC restart, and no need to prolong retention of Db2 log files for change capture. PowerExchange works in conjunction with PowerCenter to extract change data from Db2 database logs or PowerExchange Logger log files and load that data to one or more targets.