InfoLoad

logo_infoload

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

infoLoad_visuel2

  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

InfoLoad pamphlet

    Software

    Sales Contact
    software@infotel.com

    Tour Gallieni II
    36, Av. du Général de Gaulle
    93175 Bagnolet Cedex
    France

    Tél. +33 (0)1 48 97 38 38