Db2 for i CDC Connector > Introduction to Db2 for i CDC Connector
  

Introduction to Db2 for i CDC Connector

You can use Db2 for i CDC Connector to connect to a PowerExchange for Db2 for i change data capture (CDC) environment to retrieve change records for registered Db2 source tables on an IBM i system. PowerExchange captures change records for registered source tables from Db2 journal receivers. The change records are then re-logged to a remote PowerExchange Logger for Linux, UNIX, and Windows so that the Db2 for i CDC Connector can access the records.
Db2 for i CDC Connector extracts change records from PowerExchange Logger log files and sends the records to Data Integration. Data Integration can then transmit the change records to a supported target.
When you define mappings in Data Integration, you select the extraction maps that PowerExchange generated for the Db2 source tables when you registered the tables. The Db2 for i CDC Connector metadata adapter can then retrieve the source metadata from the extraction maps and store this information in the cloud.
To extract source change records from PowerExchange Logger log files, you must run the mapping tasks that are associated with the mappings. A mapping task runs to the end-of-log (EOL) in the PowerExchange Logger log files and then stops. You can manually restart the mapping task from a specific point in the logs or create a schedule that runs the mapping task on a recurring basis. If the mapping task fails, Db2 for i CDC Connector can resume processing from the point of interruption based on recovery information that is stored on the target.
Db2 for i CDC Connector must be able to connect to an active PowerExchange environment that includes the PowerExchange Logger for Linux, UNIX, and Windows. You do not need to copy the PowerExchange dbmover configuration file or PowerExchange Logger pwxccl configuration file to the Db2 for i CDC Connector system. For more information about configuring PowerExchange for Db2 for i CDC, see the PowerExchange CDC Guide for i5/OS. For more information about configuring the PowerExchange Logger for Linux, UNIX, and Windows, see the PowerExchange CDC Guide for Linux, UNIX, and Windows.
Db2 for i CDC Connector works with the Informatica Cloud Secure Agent. When you install and start the Secure Agent, it downloads the Db2 for i CDC Connector components and the PowerExchangeClient packages. When you define a runtime environment, you configure a Secure Agent group.
Note: Db2 for i CDC Connector does not work with the Hosted Agent.