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
- 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.
- 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.
- If both idxwork and index statements are specified, the index statement takes effect, in which case the idxwork statement is ignored.
- 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
<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
<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:
- Conditions
Index name: IDX1
Index storage RDAREA: USER01
Contents of idxwork statement: idxwork /hd0400
- Name of the index information file to be created
/hd0400/INDEX-IDX1-USER01-aaaa00001