You must create a Db2 for i CDC connection to connect to a stream of change records that PowerExchange captured for Db2 source tables from journal receivers on an IBM i system.
The PWX CDC Reader that is on the system where the Secure Agent runs requires the connection information to retrieve Db2 change records from PowerExchange.
You can create a Db2 for i CDC connection in Administrator or Data Integration, provided that your assigned user role allows this action. Use one of the following methods:
•In Administrator, click Connections on the navigation bar. On the Connections page, click New Connection and then enter connection details and properties for a connection that has the type of Db2 for i CDC.
•In Data Integration, when you create a mapping, click Source on the mapping canvas and then click Source in the Properties: Source panel. To create a connection, click New Connection and define a connection that has the type of Db2 for i CDC. Alternatively, if you previously defined a Db2 for i CDC connection, select it from the Connection list.
When you configure a connection, you must specify a runtime environment for the connection. The runtime environment must contain a Secure Agent with the status "Up and Running."
After you create a Db2 for i CDC connection, it becomes available for use within the organization and can be used in multiple mappings.