You must create a Db2 for i connection to connect to a PowerExchange Listener to read from or write to Db2 tables.
The PWX Bulk Reader that is on the system where the Secure Agent runs requires the connection information to move Db2 for i data from PowerExchange.
You can create a Db2 for i 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.
•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. Alternatively, if you previously defined a Db2 for i 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 connection, it becomes available for use within the organization and can be used in multiple mappings.