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 possible, always specify the index statement 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 and the idxwork statement is also omitted, the utility creates index information files in the /tmp directory of the server that contains the index.
  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-filename

(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

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

[Figure]<pathname>

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" as 1 to 167 characters). Otherwise, specify the name of a regular file.