You must create a Db2 for Linux, UNIX, and Windows (LUW) CDC connection to connect to a stream of change records that PowerExchange captured from one or more Db2 source tables.
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 LUW 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 LUW 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 LUW CDC
. Alternatively, if you previously defined a Db2 for LUW 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 LUW CDC connection, it becomes available for use within the organization and can be used in multiple mappings.