Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Environment variablesVarious environment variables affect the functionality of your HCL OneDB™ products. You can set environment variables that identify your terminal, specify the location of your software and define other parameters.
Environment variables in HCL OneDB™ productsThe topics that follow discuss (in alphabetic order) environment variables that HCL OneDB™ database server products and their utilities use.
PLOAD_SHMBASE environment variable

PLOAD_SHMBASE environment variable

The PLOAD_SHMBASE environment variable lets you specify the shared-memory address at which the High Performance Loader (HPL) onpload processes will attach. If PLOAD_SHMBASE is not set, the HPL determines which shared-memory address to use.

value: Used to calculate the shared-memory address.

If the onpload utility cannot attach, an error is issued, and you must specify a new value.

The onpload utility tries to determine at which address to attach, as follows in the following (descending) order:

Attach at the same address (SHMBASE) as the database server.
Attach beyond the database server segments.
Attach at the address specified in PLOAD_SHMBASE.

Tip: It is recommended that you let the HPL decide where to attach and that you set PLOAD_SHMBASE only if necessary to avoid shared-memory collisions between onpload and the database server.

For more information, see the HCL OneDB™ High-Performance Loader User's Guide.