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 you have specified neither the pd_tmp_directory operand in the system definition nor the TMPDIR environment variable, you must specify the idxwork statement, if possible, 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 directory shown in Table 10-2 Directory to which pdrbal outputs files as specified by the server on the server where the index storage RDAREA added by ALTER TABLE is located.
- For a HiRDB single server configuration, specify only one idxwork statement.
For a HiRDB parallel server configuration, specify as many idxwork statements as there are servers that contain the index storage RDAREAs added by ALTER TABLE. You must specify the name of the server where the index storage RDAREA is located.
- 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 configuration, 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