10.3.4 idxwork statement (specification of directory for index information files)

The idxwork statement specifies the name of a directory in which index information files are to be created automatically when the index statement is omitted in the batch index creation mode (-i c).

Criterion
If possible, always specify the idxwork statement in order to avoid a shortage of space in the /tmp directory.
Rules
  1. If the index and idxwork statements are both omitted, the utility creates index information files in the /tmp directory on the server that contains the index storage RDAREA added by ALTER TABLE.
  2. For a HiRDB/Single Server, specify only one idxwork statement.
    For a HiRDB/Parallel Server, specify as many idxwork statements as there are servers that contain the index storage RDAREAs added by ALTER TABLE.
  3. If both idxwork and index statements are specified, the index statement takes effect, in which case the idxwork statement is ignored.
  4. When the index creation process terminates normally, the system automatically deletes the index information files from the specified directory.
Organization of this subsection
(1) Format
(2) Explanation
(3) Names of the index information files to be created

(1) Format

idxwork [server-name] directory-name

(2) Explanation

(a) server-name

[Figure]<identifier> ((1-8))

Specify the name of the server used to create the directory for index information files. For a HiRDB/Single Server, do not specify the server name.

(b) directory-name

[Figure]<pathname> ((1-255))

Specify the absolute pathname of the directory in which index information files are to be created.

(3) Names of the index information files to be created

The utility assigns the following name to each created index information file:

directory-name/INDEX-index-name-index-storage-RDAREA-name-unique-character-string

The following shows an example: