Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Moving DB2 for z/OS Bulk Data with Relational Source or Target Definitions

Moving DB2 for z/OS Bulk Data with Relational Source or Target Definitions

Use the following procedure to have PowerCenter import DB2 for z/OS source or target definitions as relational data and perform the bulk data movement:
  1. In the PowerCenter Designer, click
    Source
     
    >
     
    Import from PowerExchange
    for a DB2 data source or
    Target
     > 
    Import from PowerExchange
    for a DB2 data target.
  2. In the Import from PowerExchange dialog box, select
    DB2zOS
    as the
    Source Type
    field (also displayed for a target). Also, enter the location, the DB2 subsystem ID, and any user ID or password that is required for database access. Complete the other fields, as needed.
    In the
    Location
    field, enter the PowerExchange Listener node name that you specified in the NODE statement in the dbmover.cfg file on the local PowerCenter system.
  3. In the PowerCenter Designer, create a mapping that includes the DB2 for z/OS source or target.
  4. In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX DB2zOS relational database connection. Then start the workflow to move the bulk data.

0 COMMENTS

We’d like to hear from you!