PWXPC supports restart and recovery processing. Learn how to configure your CDC sessions to use this processing.

Each source in a CDC session has unique restart information, referred to as restart tokens. PWXPC manages the CDC restart information. The PowerCenter Integration Service provides recovery for the target files and tables in CDC sessions.

To extract change data from the change stream, PWXPC provides restart information for CDC sources to PowerExchange. PowerExchange reads the change stream on the source platform and provides complete units of work (UOWs) to PWXPC. A UOW is a collection of changes within a single commit scope, which are made by a transaction on the source system. Based on the commit interval information that is specified on the CDC session connection, PWXPC periodically flushes complete UOWs to the PowerCenter Integration Service.

Target recovery and restart information is stored as the target tables and files are updated by the PowerCenter Integration Service. The PowerCenter Integration Service and PWXPC use this information to recover and restart stopped or failed sessions from the point of interruption.