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

Example Bulk Data Movement Configuration

Example Bulk Data Movement Configuration

The following figure shows an example bulk data movement configuration of PowerExchange with PowerCenter, which includes sources and targets on z/OS, i5/OS, and distributed systems:
In this example, PowerExchange uses PWXPC to integrate with PowerCenter. PowerExchange extracts bulk data from and loads bulk data to the following types of databases and files:
  • Relational databases and flat files on Linux, UNIX, and Windows
  • DB2 tables and flat files on i5/OS
  • Relational databases, nonrelational databases, and sequential data sets on z/OS
PowerExchange uses its access methods to read bulk data from and write bulk data to relational and nonrelational databases and sequential data sets on z/OS and to DB2 tables and flat files on i5/OS. On Linux, UNIX, and Windows systems, the PowerCenter Reader and Writer extracts and loads data for relational data sources and targets and flat files.
PowerExchange also can read data from and write data to DB2, Microsoft SQL Server, and Oracle tables on Linux, UNIX, or Windows.
Because the target systems are remote from the source systems, a PowerExchange Listener runs on all of these systems.

0 COMMENTS

We’d like to hear from you!