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

Introduction to IMS Bulk Data Movement

Introduction to IMS Bulk Data Movement

PowerExchange, in conjunction with PowerCenter, can move bulk data from or to an IMS database.
You must run a PowerExchange Listener on the z/OS system where the IMS database is located. Verify that this PowerExchange Listener can communicate with the PowerExchange system where the PowerExchange Navigator and PowerCenter Integration Service run.
Because IMS is a nonrelational database, you must create a data map by using the PowerExchange Navigator. PowerExchange uses data maps for the following purposes:
  • Access IMS data and metadata.
  • Create a relational row-type view of the records.
    PowerExchange requires a relational view to use SQL‑type statements to read or write bulk data.
If an IMS database descriptor (DBD) is available, you can import it from the DBDLIB library. Alternatively, PowerExchange can get the DBD metadata for source objects from the IMS catalog. When you create a data map, import the DBD metadata to define the following items:
  • Segments
  • Segment hierarchy
  • Key fields
  • Search fields
You can import DBD metadata for all or selected segments. For each IMS segment for which you import DBD metadata, you can also import a COBOL or PL/I copybook. The copybook provides detailed segment layout information, which augments and overlays the segment information from the DBD.
You can optionally create an IMS unload data set that contains the source data and then use that data set for the bulk data movement operation. To create an unload data set that PowerExchange and PowerCenter can use, use either the IBM unload utility for your IMS database type or the Unload function of the BMC Database Management for IMS solutions.

0 COMMENTS

We’d like to hear from you!