8.9.5 index statement (specification of index information file information)

The index statement specifies information about index information files.

Criteria
  • -k rorg or -k reld specified
    If you have specified neither the pd_tmp_directory operand in the system definition nor the TMPDIR environment variable, you must specify the index statement, if possible, in order to avoid a shortage of space in the /tmp directory.
    If there are many indexes or index storage RDAREAs, you should specify the idxwork statement.
  • -k ixmk statement
    Be sure to specify the index statement.
  • -k ixrc or -k ixor specified
    Specify the index statement to re-create an index in units of index storage RDAREAs or to reorganize an index (to process an index in units of indexes, specify the idxname statement).
Rules
  1. Specify one index statement for each index storage RDAREA.
  2. There is no need to specify an index statement when you are reorganizing a table with no index defined or using the index update mode.
  3. If the index statement is omitted, the utility determines the file name and creates an index information file. If the idxwork statement is omitted, the index information file is created in the directory shown in Table 8-42 Directory to which pdrorg outputs files on the server where the index is stored.
    If the utility determines the name and creates the index information file, the utility will delete the file after batch index creation is completed. However, if the index statement is specified but the -o option is omitted, the utility will not delete the file after completion of batch index creation, in which case the user must delete the file.
  4. If both the index and idxwork statements are specified, the index statement takes effect.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

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

(2) Explanation

(a) index identifier

Specify 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, specify the name of the RDAREA containing a table partition.

If you are specifying a replica RDAREA, specify its original RDAREA name in this option and then specify 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

~<path name>

Specify the absolute path name of the index information file to which index information is to be output.

If you are re-creating an index using the index information file output by the delayed batch index creation facility, you can use the name of a HiRDB file for the index information file (express "HiRDB-file-system-area-name/HiRDB-file-name" as 1 to 167 characters). Otherwise, specify the name of a regular file.