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

PowerExchange Bulk Data Movement Overview

PowerExchange Bulk Data Movement Overview

PowerExchange can efficiently move large amounts of data between different operating systems in a single operation. You can use this bulk data movement capability to materialize or completely refresh a data target, resynchronize a data source and data target, or create a data warehouse, data mart, or operational data store.
After you materialize a target, you can use PowerExchange Change Data Capture (CDC), if this option is available at your site, to update the target on a continuous basis. By moving only the change data, you can refresh data on the target faster.
PowerExchange can move bulk data between sources and targets of different types on the same operating system or on different operating systems. PowerExchange works in conjunction with PowerCenter® to extract data from and write data to relational databases, nonrelational databases, flat files, and sequential data sets. The types of data sources and targets that you can use for bulk data movement depend on your PowerExchange license.
On Linux, UNIX, and Windows systems, PowerExchange can move bulk data for the following types of data sources and targets:
  • DB2 for Linux, UNIX, and Windows tables
  • Oracle tables
  • Microsoft SQL Server tables
  • Flat files
On i5/OS systems, PowerExchange can move bulk data for DB2 for i5/OS tables and flat files.
On z/OS systems, PowerExchange can use the following types of databases and files as either bulk data sources or targets, except where noted:
  • Adabas files
  • CA Datacom databases, as data sources only
  • DB2 for z/OS tables
  • CA IDMS databases, as data sources only
  • IMS databases
  • VSAM data sets
  • Sequential data sets
For DB2 for z/OS, PowerExchange can use the DB2 LOAD utility to load data to DB2 tables. For IMS, PowerExchange can use an IMS unload data set as the source.
If the source data resides on tape, PowerExchange can read the data from the tape data sets, including data sets that have a block size greater than 32,760 bytes.
Where not otherwise noted, the maximum length of a source record for which PowerExchange can move bulk data is 144 KB.

0 COMMENTS

We’d like to hear from you!