Bulk Data Movement Guide

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

Back Next

Moving IDMS Bulk Data

Use the following procedure to move a IDMS bulk data either by using the PowerExchange Listener or a netport job. 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 IDMS source database

Port number of the PowerExchange Listener and port number of the netport job

IDMS metadata, including the subschema name and database name

z/OS user ID and password, if required by the PowerExchange SECURITY statement setting

To move IDMS bulk data:

From the PowerExchange Navigator, create a data map. Select IDMS
as the access method. 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 IDMS 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 IDMS source database. Use the node name that is specified for the netport job if the SECURITY statement is set to 2. Otherwise, use the node name that is specified for the PowerExchange Listener.

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 IDMS
.

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.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Moving IDMS Bulk Data

Moving IDMS Bulk Data