2.3.3 Setting environment variables
(1) Environment variables that need to be set by the HiRDB administrator
Set the environment variables shown in Table 2-5 in the HiRDB administrator environment.
Place the environment variables in one of the following files according to the server machine's login shell:
- #1: The PDDIR absolute path name can contain the following byte lengths:
- HP-UX, Solaris, and AIX: 128 bytes
- Linux: 27 bytes
- #2: The PDCONFPATH absolute path name can contain a maximum of 213 bytes.
- #3: For Solaris and Linux, use LD_LIBRARY_PATH; for AIX 5L, use LIBPATH.
For details about the LANG and PDLANG environment variable settings, see the manual HiRDB Version 8 UAP Development Guide.
- Note
- It is not necessary to set the TMPDIR environment variable. When TMPDIR is omitted, HiRDB creates temporary files in $PDDIR/tmp. When TMPDIR is set and HiRDB commands or utilities are interrupted, HiRDB may create files beginning with pdcmd or plcmd in the directory specified by TMPDIR. If some files that begin with pdcmd or plcmd remain in that directory after completion of the HiRDB commands or utilities, you must delete them, such as by using the operating system's rm command.
(2) Environment variables that need to be set by users who execute UAPs
If a UAP is to be executed, the HiRDB administrator must set a client environment definition in the environment variables for each applicable user. The format of the client environment definition depends on the client machine's OS or shell being used. For details about the information to be set in the client environment definition, see the manual HiRDB Version 8 UAP Development Guide.
(3) Environment variables that need to be set by users who define tables and indexes
If tables and indexes are to be defined, you need to set the following environment variables for each executing user. Shown here are the environment variables to be set in the Bourne shell environment.
- PDHOST=HiRDB-server's-host-name[,secondary-HiRDB-server's-host-name]
This environment variable specifies the host name of the HiRDB server to be connected. For a HiRDB/Parallel Server, specify the host name of the server machine at which the system manager is defined. If PDFESHOST is specified, you can specify the host name of PDFESHOST. When the host name of PDFESHOST is specified, the HiRDB server can be connected even if an error occurs on the system manager unit.
- $PDUSER=authorization-identifier/password
This environment variable specifies the authorization identifier and password. You need to assign the schema definition privilege to the user specified here. For the authorization identifier specified for defining a schema (CREATE SCHEMA), assign the authorization identifier specified by this environment variable. To use lower-case alphabetic characters for the authorization identifier and password, use the "authorization-identifier"/"password" format.
- PDNAMEPORT=HiRDB-server's-port-number
This environment variable specifies the port number of the HiRDB server. Specify the port number of the HiRDB system that accesses the host specified in PDHOST.