Moving DB2 for z/OS Bulk Data with Relational Source or Target Definitions
Moving DB2 for z/OS Bulk Data with Relational Source or Target Definitions
Use the following procedure to have PowerCenter import DB2 for z/OS source or target definitions as relational data and perform the bulk data movement:
In the PowerCenter Designer, click
Source
>
Import from PowerExchange
for a DB2 data source or
Target
>
Import from PowerExchange
for a DB2 data target.
In the Import from PowerExchange dialog box, select
DB2zOS
as the
Source Type
field (also displayed for a target). Also, enter the location, the DB2 subsystem ID, and any user ID or password that is required for database access. Complete the other fields, as needed.
In the
Location
field, enter the PowerExchange Listener node name that you specified in the NODE statement in the dbmover.cfg file on the local PowerCenter system.
In the PowerCenter Designer, create a mapping that includes the DB2 for z/OS source or target.
In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX DB2zOS relational database connection. Then start the workflow to move the bulk data.