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:

• Bourne shell: $HOME/.profile
• C shell: $HOME/.cshrc
  

  Table 2-5 Information to be set in HiRDB administrator defined environment variables

  Environment variable	Information to be set
  PDDIR#1	Specifies the absolute path name of the HiRDB directory.
  PDCONFPATH#2	Specifies the absolute path name of the directory that is used to store the HiRDB system definition file. The unit control information definition always uses the file under $PDDIR/conf, regardless of this setting. If the PDCONFPATH operand is specified in the unit control information definition, the same setting must be specified here as in that PDCONFPATH operand.
  PATH	Adds $PDDIR/bin.
  SHLIB_PATH#3	Adds $PDDIR/lib.

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

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.

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.