Bulk Data Movement Guide

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

Back Next

Materializing a Target from an IMS Database

Use the following general procedure to move bulk data from an IMS database to a relational or nonrelational target. This procedure assumes that you are using PWXPC to integrate PowerExchange with PowerCenter.

Before you begin, complete these tasks:

If you plan to create a DL/1 Batch data map, create a netport job and complete the other configuration tasks required to configure PowerExchange for bulk data movement with a DL/1 batch data map.

If you plan to create an IMS ODBA data map, complete the configuration tasks required to configure PowerExchange for bulk data movement with an IMS ODBA data map.

To materialize a target from an IMS database:

Create the target database structure.

From the PowerExchange Navigator, create a data map for the IMS source.

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.

Also, you can view the IMS segment hierarchy that was imported from the DBD source by right-clicking the data map and clicking Display IMS Hierarchy
.

Send the data map to the PowerExchange Listener on the remote z/OS system. Select the data map in the Resource Explorer and click File
> Send to Remote Node
.

Run a database row test on the table view of the IMS source or target to verify that actual data can be returned from the IMS database.

In the PowerCenter Designer, import the PowerExchange data map and create a mapping.

When you import the data map, in the Location
field, enter the PowerExchange Listener node name that you specified in the NODE statement of the local dbmover.cfg file. Also, specify IMS
in the Source Type
field. This field is also displayed for targets.

You can create a Lookup transformation to get related values or to determine if source records already exist on the target. Add the Lookup transformation to the 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.

If you plan to use PowerExchange CDC to update the target, you must set up restart tokens.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Materializing a Target from an IMS Database

Materializing a Target from an IMS Database