Bulk Data Movement Guide

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

Back Next

Moving DB2 for i5/OS Bulk Data - SEQ Access Method

Use the following procedure to move DB2 for i5/OS bulk data. This procedure assumes that you use the SEQ access method and PWXPC.

To move DB2 for i5/OS bulk data by using the SEQ access method:

In the PowerExchange Navigator, create a data map.

Select SEQ
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. To do so, select the data map in the Resource Explorer and click File
>
Import Copybook
.

In the File Name
field, specify the i5/OS file using one of the following formats:

library
/file

library
/file
(member
)

Open the data map in the Resource Explorer, and click the Record
or Table
view to verify that the metadata was successfully retrieved.

To send the data map to the PowerExchange Listener on the remote i5/OS system, select the data map in the Resource Explorer and click File
>
Send to Remote Node
.

In the Location
field, enter the value 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 actual data can be returned from the Datacom source database.

From 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 is specified in the NODE statement of the dbmover.cfg on local system.

From the PowerCenter Workflow Manager, define a workflow and a 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 DB2 for i5/OS Bulk Data - SEQ Access Method

Moving DB2 for i5/OS Bulk Data - SEQ Access Method