You must have a functional on-premises PowerExchange environment that can retrieve records from Db2 data map sources on a z/OS system. The Db2 Data Map Connector retrieves records by using the data map metadata.
PowerExchange, in conjunction with Data Integration, can move bulk data from Db2 data map sources on z/OS. These types of sources and targets use the DB2 access method. Hereafter, the term Db2 data map is used to refer to Db2 data maps on z/OS.
You must have a license that allows your organization to use the Db2 Data Map Connector and PowerExchangeClient packages on a z/OS system. On each system from which you plan to use Db2 Data Map Connector, install the Secure Agent. After you start the Secure Agent the first time, the Db2 Data Map Connector and PowerExchangeClient package are installed locally. You then can use Cloud Data Integration, Administrator, and Monitor interfaces to configure Db2 data map connections, mappings, and mapping tasks and to run and monitor mapping tasks.
The following image shows the general architecture of the Db2 Data Map Connector components in relation to Cloud Data Integration and the remote source system:
This configuration spans the following on-premises systems:
•The Windows system where the PowerExchange Navigator client runs.
•The system where the data sets and PowerExchange Listener run.
•The system where the Db2 Data Map Connector components and Secure Agent run.
Based on this configuration, the following processing occurs:
1You defined a data map for each Db2 source in the PowerExchange Navigator. The data map provides a relational type view of the records. It is used to provide metadata and data access.
2When you design a mapping in Data Integration, you associate the Source transformation with a Db2 Data Map connection. You can define the connection in either Data Integration or Administrator. The PWX Bulk Metadata Adapter then uses the connection to connect to the PowerExchange Listener and retrieve data map metadata files for the source from the PowerExchange Listener.
In the mapping, you must also define a Target transformation and connection and map the source fields to target fields.
3The Secure Agent in conjunction with Data Integration sends the data map metadata to the Informatica Intelligent Cloud Services repository in the cloud.
4When you run the mapping task that is associated with the mapping, all of the metadata, connection properties, mapping information, advanced source properties, runtime properties, and advanced session properties are pushed down to the on-premises Secure Agent in the form of a session .xml file.
5The PWX Bulk Reader on the Secure Agent machine communicates with the PowerExchange Listener to retrieve the records from the PowerExchange Listener.
6Data Integration transmits the records to the mapped target.
Alternative configurations of PowerExchange with the Db2 Data Map Connector components and Cloud Data Integration are possible. For example:
•The PowerExchange Navigator can run on any supported Windows system, including a Windows system where the Db2 Data Map Connector and Secure Agent run.
