Environment Variables

Home | Previous Page | Next Page High-Performance Loader Overview >

Environment Variables

The HPL is part of the database server, so you must start the database server before you use the HPL.

Important:

Before you start the database server and use HPL, you must set these environment variables:

INFORMIXDIR
ONCONFIG
INFORMIXSERVER
LD_LIBRARY_PATH

The INFORMIXDIR, ONCONFIG, and INFORMIXSERVER environment variables are documented in the IBM Informix: Guide to SQL Reference.

Some computers use the LD_LIBRARY_PATH environment variable for shared libraries. The name of this environment variable is platform dependent. See your operating system documentation for the name of the environment variable that specifies the search path for shared libraries. Then see the IBM Informix Dynamic Server machine notes for information about LD_LIBRARY_PATH.

You can use the IFX_ONPLOAD_AUTO_UPGRADE environment variable with the ipload or onpladm utilities to automatically upgrade the onpload database the first time you invoke an HPL utility using the ipload or onpladm command after you migrate to a new database server version. You cannot use the IFX_ONPLOAD_AUTO_UPGRADE environment variable with the onpload utility. For more information on this environment variable, see the IBM Informix: Migration Guide.

In addition to the environment variables listed above, the following environment variables pertain to the HPL:

DBONPLOAD
PLCONFIG
PLOAD_SHMBASE
PLOAD_LO_PATH
PLOAD_SHMAT

Tip:

To maximize available memory and scan resources, HPL automatically sets the PDQPRIORITY environment variable to 100, if it is not already set. If the PDQPRIORITY environment variable is set, HPL uses that value. If the PDQPRIORITY environment variable is set to 0, then HPL cannot unload multiple devices. For more information on this environment variable, see the IBM Informix: Guide to SQL Reference.