Review the Db2 for i Connector rules and guidelines before you begin creating connections, mappings, and mapping tasks.
•You can use Db2 for i connections for sources and targets.
•Db2 for i Connector connects to the PowerExchange Listener on the IBM i source system by using the Listener Location property that you specify in the Db2 for i connection definition. On the Connector system, you do not need to create a local copy of the dbmover.cfg configuration file that contains a NODE statement pointing to the PowerExchange Listener.
•If you upgrade your system to a later PowerExchange version, you must stop the Secure Agent that connects to the older PowerExchange Listener before you try to connect to the upgraded PowerExchange Listener. After you edit the connection properties to specify the upgraded PowerExchange Listener, restart the Secure Agent before you try to establish the connection again. For more information, see Upgrading to a new version of PowerExchange.
•PowerExchange does not move data for Db2 for i columns that have the following data types:
- BLOB, CLOB, or DBCLOB
- DATALINK
- DECFLOAT
- DISTINCT
- ROWID
Columns that have these data types will not be included in the data that Db2 for i Connector retrieves from PowerExchange.
•The PowerExchange Listener on the IBM i system can compress or encrypt the data that it sends to the PWX Bulk Reader component of Db2 for i Connector, depending on how you set the Compression and Encryption properties for the source connection.