A Significant Reduction in costs during load times

infoLoad_visuel1InfoLoad performs:

  • much faster loading in a single step
  • parallel processing of several operations usually done sequentially (data loading, Index creation, Full Image Copy and RUNSTATS).

Furthermore, InfoLoad, by working outside DB2, significantly reduces the CPU and ELAPSED times needed for loading.

User friendly

A user-friendly ISPF interface for:

  • selecting DB2 objects for loading
  • suitable JCL generation and storage

Automatic and dynamic allocation of work files needed for loading.

A Simple operating mode


  1. Entry data is checked and converted if necessary.
  2. The entry file can be an FIC.
  3. Loads table spaces and creates indices.
  4. Updates the DB2 catalogue.
  5. Creates one or more Full Image Copies.
  6. Creates a catalogue update file for RUNSTATS data and a file for rejections if necessary.
  7. Creates a Discard file.
  8. Writes an execution report.

Additional functionalities

  • Loading part of a Full Image Copy directly loads a tablespace directly in another DB2, without prior unloading.
  • InfoLoad allows OBID translation, thus facilitating data transfer from table to table, or from DB2 subsystem to DB2 subsystem.
  • During loading, InfoLoad converts DB2 data from one type to another.
  • InfoLoad imports non DB2 data into DB2 tables.
  • InfoLoad sorts entry data according to the Index Cluster.
  • During sorting, the Infoload PRECHECK option controls data entry and avoids pointless loading of data where errors are detected.
  • Infoload produces one or more Full Image Copies during the loading phase.
  • While running, Infoload collects statistics (RUNSTATS) on the loaded data and generates un update file for the DB2 catalogue.
Plaquette technique d'InfoLoad



    Sales Contact - Infotel Corporation

    PO Box 47517
    33743 St Petersburg
    United States

    Tél. +(1) 727 343 5958
    Fax +(1) 727 343 5968