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 on the HiRDB installation drive.

Rules

1. If the index and idxwork statements are both omitted, the utility creates index information files in the HiRDB-installation-drive\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