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

Materializing a Target from a DB2 Image Copy

Use the following procedure to create a full image copy of a DB2 source table space and use it to materialize a target:

Create the JCL and control cards for creating the full image copy.

Submit the job for the DB2 COPY utility manually or from a job scheduler or a batch job. When the DB2 DSNUTILB program reads the control cards, it invokes the COPY utility to create the full image copy.

Create a target database structure, such as a table.

In the PowerCenter Designer, create a mapping. Include the DB2 table for which you created the image copy as the source and the database object from step 3 as the target.

In the PowerCenter Workflow Manager, create a connection, workflow, and session.

Create a new application connection, and select

PWX NRDB Batch

as the connection type. If you want to enable offload processing, select

Filter After

for the

Offload Processing

attribute.

When you configure the session, select PowerExchange Reader for DB2 Image Copy
as the reader, and select the application connection that you just created from the list of connections.

To specify the image copy, perform one of the following actions:

To read the latest image copy, do not enter a data set name in the Image Copy Data Set
attribute for the reader.

To read a full image copy other than the latest one, enter the data set name of that image copy in the Image Copy Data Set
attribute for the reader.

To read a full image copy file that was created on a different DB2 subsystem, enter the data set name of that image copy in the Image Copy Data Set
attribute for the reader, and select

Disable consistency checking

If you select the

Disable consistency checking

property and use an image copy that was created on a different DB2 subsystem or with a previous DB2 version, the following additional restrictions apply:

The table definition in the catalog of the DB2 subsystem being used to read the image copy must correctly reflect the table definition when the image copy was created.

The image copy must contain data for only one table.

The image copy must be created on a subsystem at the same DB2 version as the subsystem used to read the image copy.

Start the workflow to move the image copy data to the target table.

If you plan to use PowerExchange CDC to update the target, you must set up restart tokens based on the event markers from the QUIESCE TABLESPACE step. For information about setting up restart tokens, see PowerExchange Interfaces for PowerCenter
.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Materializing a Target from a DB2 Image Copy

Materializing a Target from a DB2 Image Copy