IBM® Informix® 12.10

High-Performance Loader User’s Guide

These topics describe how to use the IBM® Informix® High-Performance Loader (HPL) to load and unload large quantities of data efficiently to or from an Informix database.

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 IBM Informix release notes.

These topics are taken from IBM Informix High-Performance Loader User's Guide.

Send feedback | Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.

Release date: March 2013