5.4.6 idxwork statement (specification of index information file directory)

When the index statement is omitted, the idxwork statement specifies the name of the directory in which an index information file is created automatically.

Criterion
Specify the idxword statement, if possible, so as to avoid a space shortage in the /tmp directory.
Rules
  1. If the index and idxword statements are both omitted, the system creates an index information file in the /tmp directory on the server where the index statement RDAREAs are located.
  2. You can specify as many idxwork statements as follows:
    HiRDB/Single Server:
    Specify only one idxwork statement.
    HiRDB/Parallel Server:
    Specify as many idxwork statements as there are servers in which the partitioned indexes are stored for a row-partitioned table. For a table that is not partitioned, or when loading data in units of RDAREAs for a partitioned table, specify only one idxwork statement.
  3. If both index and idxwork statements are specified, the index statement takes effect, in which case the system ignores the idxwork statement.
  4. If no index has been defined for the target table, do not specify the idxwork statement.
Organization of this subsection
(1) Format
(2) Explanation
(3) Notes

(1) Format

idxwork [server-name] directory-name

(2) Explanation

(a) server-name

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

Specifies the name of the server at which the index information file is to be created.

HiRDB/Single Server
Do not specify this operand for a HiRDB/Single Server. The name of a single server is ignored, if specified.
HiRDB/Parallel Server
Specify the name of the server at which the index information file is to be created.
(b) directory-name

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

Specifies the absolute pathname of the directory in which the index information file is to be created.

(3) Notes

This subsection shows the name of the index information file that is created automatically.

(a) When the inner replica facility is not used

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

Example:

If the directory name is /hd400, index name is IDX1, and the name of the index storage RDAREA is USER01 in the idxwork statement, the index information file is created under the following name:

/hd0400/INDEX-IDX1-USER01-aaaa00001

(b) When the inner replica facility is used

directory-name/INDEX-index-name
-index-storate-RDAREA-name-GNgeneration-number-unique-character-string

Example:

If the directory name is /hd400, the index name is IDX2, the names of the index storage RDAREA is USER01, and the generation of the target RDAREA is 2 in the idxwork statement, the index information file is created under the following name:

/hd0400/INDEX-IDX2-USER01-GN2-aaaa00002