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 DB2 Bulk Data

Use the following procedure to move bulk data from or to a DB2 for Linux, UNIX, and Windows database. This procedure assumes that you are using PWXPC to integrate PowerExchange with PowerCenter.

Before you begin, get the following information:

DB2 database name

Table names for the DB2 source or target tables

Database user ID and password

From the PowerExchange Navigator, you can preview DB2 source data before moving it. Create a personal metadata profile and perform a database row test on it. The PowerExchange Navigator displays metadata, such as datatype, date format, and CCSID, for each DB2 column.

To move DB2 bulk data:

In the PowerCenter Designer, click Source
> Import from PowerExchange
for a DB2 data source or Target
> Import from PowerExchange
for a DB2 data target.

In the Import from PowerExchange
dialog box, enter the following required attributes:

In the Location
field, enter the PowerExchange Listener node name that you specified in the LISTENER statement of the local dbmover.cfg file if the DB2 database is on the local system where the PowerCenter runs. If the DB2 database is on another system, enter the node name that is specified in the NODE statement of the local dbmover.cfg.

In the User name
and Password
fields, enter the user ID and password for accessing the DB2 source or target tables.

In the Source Type list, select DB2LUW.

In the Database Name
field, enter the DB2 database name.

Complete the optional attributes as needed.

In the PowerCenter Designer, create a mapping that includes the DB2 source or target.

In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX DB2LUW relational database 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 DB2 Bulk Data

Moving DB2 Bulk Data