5.4.5 index statement (specification of index information file information)

When executing data loading in the batch index creation or index information output mode, use the index statement to specify information about the index information file to which index information is to be output.

Criteria
Specify the index statement, if possible, so as to avoid a space shortage in the /tmp directory.
If there are many indexes or index storage RDAREAs, you should specify the idxwork statement.
Rules
  1. Specify as many index statements as there are (the number of indexes [Figure] number of index storage RDAREAs).
  2. When the index statement is omitted, the system creates an index information file under the directory specified in the idxwork statement. If the idxwork statement is also omitted, the system creates an index information file in the /tmp directory on the server that contains the index storage RDAREAs.
  3. If you specify both index and idxwork statements, the index statement takes effect.
  4. If no index has been defined for the target table, do not specify the index statement.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

index index-identifier [RDAREA-name] index-information-filename

(2) Explanation

(a) index-identifier

Specifies the identifier of the index.

The system treats an index identifier enclosed in double quotation marks (") as case sensitive; otherwise, the system treats it as all uppercase letters. Enclose an index identifier in double quotation marks if it contains a space.

(b) RDAREA-name

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

For a row partitioned table, this operand specifies the name of the RDAREA containing the index.

If you are specifying a replica RDAREA, specify the original RDAREA name for RDAREA-name and the target generation number in the -q option.

The system treats an RDAREA name enclosed in double quotation marks as case sensitive; otherwise, the system treats it as all uppercase letters. Enclose an RDAREA name in double quotation marks if it contains a space.

(c) index-information-filename

[Figure]<pathname>

Specifies the absolute pathname of the index information file to which index information is to be output.

This index information file must be in the server machine or back-end server where the index storage RDAREA is located.