IBM® Informix® 12.10

Environment variables needed for the HPL

The High-Performance Loader (HPL) is part of the database server, so you must start the database server before you use the HPL. Before you start the database server and use HPL, you must set environment variables.

The following environment variable must be set:

INFORMIXDIR
ONCONFIG
INFORMIXSERVER
LD_LIBRARY_PATH

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 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 run an HPL utility by 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.

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.

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