InfoLoad® for DB2 on z/OS

A Significant Reduction in Load Costs

InfoLoad:

  • Loads much faster in a single step
  • Handles several operations in parallel that are usually performed sequentially (data load, index creation, Full Image Copy and Runstats).

In addition, because InfoLoad runs outside DB2, the CPU and elapsed times required for the load process are significantly decreased.

InfoLoad

Very Easy to Use

A user-friendly ISPF interface to:

  • Select the DB2 objects to be loaded
  • Generate and store the suitable JCL.

The work files required for load are allocated dynamically and automatically.

A Simple Process Flow

  1. The input data is checked and converted where required.
  2. The input file can be a FIC.
  3. The Tablespace is loaded and the indexes are created.
  4. The DB2 catalog is updated.
  5. One or more Full Image Copies are created.
  6. A catalog update file is created for the Runstats as well as an exception file where applicable.
  7. A discard file is created.
  8. An execution report is output.
InfoLoad

Additional Features

  • Loading from a Full Image Copy allows a Tablespace to be loaded directly into another DB2 without first unloading it
  • InfoLoad allows translation of OBIDs, thereby facilitating transfers between tables and between DB2 substystems
  • During load, InfoLoad can convert DB2 data from one type to another
  • InfoLoad can import non-DB2 data into DB2 tables
  • InfoLoad can sort input data based on the Clustering index
  • During the sort, InfoLoad’s Precheck option can be used to check the input data and avoid loading data when errors are detected
  • InfoLoad can generate one or more Full Image Copies during load
  • While running, InfoLoad collects statistics (Runstats) relative to the data loaded and generates a DB2 catalog update file.