High-Performance Loader User's Guide

The describes how to use the HCL Informix® to load and unload large quantities of data efficiently to or from Informix databases.

These topics describe:
  • The architecture of HPL
  • The onpload utility that allows you to control HPL from a script.
  • The onpload database that maintains information about load and unload jobs that you have prepared.
  • The ipload graphical user interface (GUI).
  • The onpladm utility.

The ipload utility is a UNIX™ application that helps users prepare load and unload jobs for both UNIX and Windows™. The onpladm utility is a command-line version of the ipload utility that operates on both UNIX and Windows.

The first section introduces the HPL, provides a general overview of the tasks that the HPL performs, describes the architecture of the HPL, and includes two tutorial examples that take you through the process of loading and unloading data.

The second section introduces the ipload utility, a graphical user interface that you can use to set the parameters for the HPL.

Subsequent sections give details about developing the onpload database by using the individual components of the ipload, onpload, and onpladm utilities.

These topics are written for the following users:
  • Database administrators
  • Database server administrators
These topics assume that you have the following background:
  • A working knowledge of your computer, your operating system, and the utilities that your operating system provides.
  • Some experience working with relational databases or exposure to database concepts.
  • Some experience with computer programming.
  • Some experience with database server administration, operating-system administration, or network administration.

For information about software compatibility, see the HCL Informix release notes.