PowerExchange, in conjunction with PowerCenter, can move bulk data from or to DB2 for z/OS tables.

You can optionally create a DB2 image copy or unload file for a data source and then use that image copy or unload file for the bulk data movement operation. To create an image copy that PowerCenter can use, you must use the DB2 online COPY utility or a utility that produces a COPY-compatible image copy. Create a full image copy of either a DB2 source table space or table space partition.

Also, you can use the DB2 LOAD utility to load bulk data to a DB2 for z/OS target. PowerExchange provides JCL and control card templates for running the DB2 LOAD utility. PowerExchange also generates a data file that contains the data for the LOAD utility to load to the DB2 target. If appropriate, you can run a bulk data LOAD operation as a task of a netport job.

If you use PowerExchange with any of these utilities, you must perform some additional configuration tasks for the bulk data movement.

For relational sources and targets such as DB2 for z/OS tables, you do not need to create a data map. PowerCenter can import the metadata that PowerExchange reads from the DB2 catalog to create source or target definitions. PowerExchange uses these definitions to access the source or target tables when PowerCenter runs the bulk data movement.

However, PowerCenter cannot treat DB2 sources such as DB2 unload files as relational sources. To have PowerCenter treat DB2 data sources as nonrelational sources, you must create a data map with the DB2 or DB2UNLD access method in PowerExchange Navigator. Then import that data map into PowerCenter to create nonrelational-type source definitions.