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

Rules and Guidelines for Bulk Data Offload Processing

Rules and Guidelines for Bulk Data Offload Processing

The following restrictions apply to bulk data movement operations that use offload processing:
  • You cannot perform bulk data offload processing for data maps that use any of the following options:
    • User access methods
    • User-defined fields that invoke programs by using the CALLPROG function
    • Record-level exits
  • For source data maps that have an
    Encoding
    setting other than
    Default
    in the Access Method dialog box, specify
    Filter After
    for the
    Offload Processing
    option on the PWX NRDB connection. For these data maps, do not specify
    Filter Before
    for the
    Offload Processing
    option.
  • If you select
    Filter Before
    for an IMS unload file DB2 for z/OS image copy data source, PowerExchange changes the selection to
    Filter After
    .
  • You cannot include multiple data targets in a mapping that point to the same VSAM file.
  • Only inserts to data targets are supported. Deletes and updates are not supported.
  • The data map for a data target must not use record-level exits.

0 COMMENTS

We’d like to hear from you!