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
If you have specified neither the pd_tmp_directory operand in the system definition nor the TMPDIR environment variable, 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 utility creates an index information file and assigns a file name to it. If the idxwork statement is omitted, the utility creates the 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.
    When the utility has created an index information file and assigned a file name to it, the utility deletes the file after batch index creation is completed (unless the index statement is specified with the -o option omitted, in which case the user must delete the file).
  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
(3) Notes

(1) Format

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

(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

~<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-file-name

~<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.

(3) Notes

For the index information file name, do not specify the name of a file under a directory to which NFS is allocated.