From the PowerExchange Navigator, create a data map. In the

Access Method

list, select

DB2UNLD

if the data source is a DB2 unload file or

DB2

if the data source is a DB2 table that requires a data map. To import metadata about data source records and fields, also select the

Import Record Definitions

option.

Open the data map in the Resource Explorer, and click the “record” or “table” view to verify that the metadata was successfully retrieved.

Send the data map to the PowerExchange Listener on the remote DB2 for z/OS system. In the Resource Explorer, select the data map and click

File

 

>

 

Send to Remote Node

. This step enables PowerExchange extraction routines to access the data map at runtime.

Run a database row test on the table view of the metadata to verify that data can be returned from the DB2 source database.

In the PowerCenter Designer, import the PowerExchange data map. For the source type, select

DB2UNLD

for an unload data map or

DB2MAP

for a DB2 table. In the

Location

field, enter the PowerExchange Listener node name that you specified in the NODE statement of the local dbmover.cfg file. Complete the other fields, as needed.

Create a mapping.

In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX NRDB Batch application connection. One of the following readers is automatically selected, depending on the data source: