PowerExchange Interfaces for PowerCenter

10.5.2
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

CDC Batch and Continuous Extraction Modes

PowerExchange can write change data to PowerExchange Condense condense files on IBM i or z/OS systems or to PowerExchange Logger for Linux, UNIX, or Windows (LUW) log files on LUW systems, instead of providing a real-time change stream. When a PowerCenter CDC session runs, PWXPC extracts the change data from the PowerExchange condense files or log files.

PowerExchange Condense is an optional component that runs on IBM i (i5/OS) or z/OS systems. The PowerExchange Condense change stream contains data changes in time sequence order. As a result, the changes in a single unit of work (UOW) are not contiguous in the change stream. The UOW Cleanser component reconstructs the UOWs into complete and consecutive UOWs based on transaction end time and then writes the reconstructed UOWs to condense files.

The PowerExchange Logger for LUW is also an optional component. The PowerExchange Logger for LUW writes only successful UOWs to its log files, in chronological order based on end time.

PWXPC can extract change data from PowerExchange condense files or log files in one of the following modes:

Batch extraction mode
. Uses a PWX CDC Change connection and the PowerExchange CAPX access method to extract change data in batch. Extraction processing stops after data from all of the condense files or log files is read.

Continuous extraction mode
. Uses a PWX CDC Real Time connection and the PowerExchange CAPXRT access method to extract change data continuously from PowerExchange condense files or log files. Extraction processing runs until stopped.

PWXPC connects to PowerExchange through the PowerExchange Call Level Interface (SCLI). PowerExchange reads the change data from each log file or condense file only once, in a single pass, for all sources in the mapping.

The following image shows the data flow of logged change data from PowerExchange through PWXPC and PowerCenter to the target tables:

Data flows from the data source to PowerExchange Logger for LUW log files or PowerExchange Condense condense files and then to the PowerExchange Listener. From there, data flows across the network to the PowerExchange SCLI > PowerCenter Integration Service > target table.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

CDC Batch and Continuous Extraction Modes

CDC Batch and Continuous Extraction Modes