Bulk Data Movement Guide

10.5.3
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Moving Datacom Bulk Data

Use the following procedure to perform a Datacom bulk data movement. This procedure assumes that you are using PWXPC to integrate PowerExchange with PowerCenter.

Before you begin, gather the following information:

TCP/IP address of the host that contains the Datacom source database

Datacom database name and ID

Your MVS user ID and password, if required by the PowerExchange SECURITY statement setting

To move Datacom bulk data:

In the PowerExchange Navigator, create a data map.

Click DATACOM
in the Access Method
list. To import metadata about records and fields, also select the Import Record Definitions
option.

If you do not select the Import Record Definitions
option, you can import the metadata later. Open the data map in the Resource Explorer and click File
> Import Copybook
.

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

Send the data map to the PowerExchange Listener on the remote Datacom 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.

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

If you do not complete this step, you are prompted to send the data map to the remote node when you run a database row test.

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

In the PowerCenter Designer, import the PowerExchange data map. Click Sources
>
Import from PowerExchange
. Then enter the following required attributes:

In the Location
field, enter the PowerExchange Listener node name that you specified in the NODE statement of the dbmover.cfg file.

In the User name
and Password
fields, enter your z/OS user ID and password, if required by the SECURITY statement setting.

In the Source Type
list, select DATACOM
.

Complete the optional attributes as needed. Then connect to PowerExchange and import the data map.

In the PowerCenter Designer, create a mapping.

In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX NRDB Batch application connection. Then start the workflow to perform the bulk data movement operation.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Moving Datacom Bulk Data

Moving Datacom Bulk Data