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:

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:
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.

Copyright© 2018 HCL Technologies Limited