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
If you have specified neither the pd_tmp_directory operand in the system definition nor the TMPDIR environment variable, specify the idxwork 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 utility creates an index information file in the directory shown in Table 5-58 Directories to which pdload outputs files on the server where the index storage RDAREAs are located.
  2. You can specify as many idxwork statements as follows:
    HiRDB single server configuration:
    Specify only one idxwork statement.
    HiRDB parallel server configuration:
    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. You must specify the name of the server where the index storage RDAREAs are located.
  3. If both index and idxwork statements are specified, the index statement takes effect, in which case the system ignores 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

~<identifier> ((1-8))

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

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

~<pathname> ((1-255))

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

(3) Notes

(a) About the name of the index information file that is created automatically

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

[Figure]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

[Figure]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

(b) About the directory used to create index information files

Do not allocate NFS to a directory that is specified in the idxwork statement.