Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

10.3.3 index statement (specification of index information file information)

When creating an index in the batch index creation mode (-i c), the index statement specifies information about an index information file to which index information is output.

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

Rules
  1. Specify one index statement for each index storage RDAREA added by ALTER TABLE.
  2. There is no need to specify an index statement for a table with no index defined.
  3. If the index statement is omitted and the idxwork statement is also omitted, the utility creates an index information file in the directory shown in Table 10-2 Directory to which pdrbal outputs files as specified by the server.
  4. If both index and idxwork statements are specified, the index statement takes effect.
  5. If a specified index information file already exists, the utility overwrites the file.
  6. When the index creation process terminates normally, the system automatically deletes the specified index information file.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

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

(2) Explanation

(a) index-identifier

~<identifier> ((1-30))

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))

Specify the name of the index storage RDAREA that was added by ALTER TABLE.

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>

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

This must be the name of a regular file.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.