15.2.4 workdir statement

The workdir statement specifies the directory to which work files used during execution of pddbst are to be output. pddbst uses work files for executing database condition analysis and for sorting data.

Rules
  1. Only one workdir statement can be specified in the control statement file.
  2. When the workdir statement is omitted, the utility creates work files in the directory shown in the table below on the host that contains the single server or where the system manager is located. These files are deleted when pddbst is terminated; however, they may remain in the system if pddbst terminates abnormally.

    Table 15-1 Directory to which pddbst outputs work files

    workdir statementpd_tmp_directory operand in the system definition
    SpecifiedOmitted
    TMPDIR environment variable#
    SpecifiedOmitted
    SpecifiedDirectory specified in the workdir statement
    OmittedDirectory specified in pd_tmp_directoryDirectory specified in TMPDIR/tmp directory
    #: Environment variable specified in the command execution environment

Organization of this subsection
(1) Format
(2) Explanation

(1) Format

 workdir dir=directory-name-for-work-files

(2) Explanation

(a) directory-name-for-work-files

~<path name> ((up to 1,000 bytes))

Specifies the absolute path name of the directory to which work files are to be output.

Rules
  1. For a HiRDB parallel server configuration, specify a directory on the host where the system manager is located.
  2. The HiRDB administrator must have access privileges to the specified directory.
  3. If the directory name contains a space, enclose the entire directory name in double quotation marks (").
  4. If the specified directory does not contain a needed file, the utility creates the file; if the directory already contains a needed file, the utility overwrites the existing file.