You can optionally use PowerExchange, in conjunction with PowerCenter, to move bulk data from or to a DB2 for Linux, UNIX, and Windows database.

Because DB2 is a relational database, you do not need to create a data map from the PowerExchange Navigator. You can define the bulk data movement entirely from the PowerCenter Designer and Workflow Manager. In the PowerCenter Designer, you can import the DB2 source or target metadata that PowerExchange reads from the DB2 catalog to create the source or target definitions.

If the DB2 database is on a system that is remote from the system or systems where the PowerExchange Navigator, PowerCenter Client, and PowerCenter Integration Service run, you must run an additional PowerExchange Listener on the remote system and verify that PowerExchange can communicate with it.

Alternatively, you can use the following bulk data movement strategies: