8.9.6 idxname statement (specification of index information)

The idxname statement specifies information about an index to be re-created or reorganized.

Criterion
Specify the idxname statement to re-create or reorganize an index in units of indexes (to process an index in units of index storage RDAREAs, specify the index statement).
Rules
  1. You can specify as many idxname statements as there are indexes. However, if name=* is specified, then only one idxname statement can be specified, in which case specifying more than one idxname statement results in an error.
  2. If the idxname statement is specified, the utility processes all index storage RDAREAs that constitute the index. This means that multiple index statements may be replaced by only one idxname statement.
  3. When the idxname statement is specified, the utility uses only one directory to output index information files, requiring a large space for the directory. If the idxwork statement is omitted and there is not much space available in the /tmp directory, a space shortage may occur. In such a case, specify a directory with sufficient free space in the idxwork statement.
Organization of this subsection
(1) Format
(2) Explanation
(3) Relationship between operands and the execution environment

(1) Format

idxname name=index-identifier [server=server-name[,server-name]...]

(2) Explanation

(a) name=index-identifier

Specifies the identifier of the index.

You can specify an asterisk (*) for the index identifier, in which case the utility re-creates all indexes defined for the table.

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) server=server-name

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

For a HiRDB/Parallel Server, this option specifies a server name.

If you specify a server name, the utility processes only those indexes at the specified server. If you omit this option, the utility processes all indexes at all servers.

(3) Relationship between operands and the execution environment

The following table shows the relationship among the name operand, server operand, and execution environment:

name operandserver operandExecution environment
HiRDB/Single ServerHiRDB/Parallel Server
index- identifierserver-nameNot applicable.The utility processes all index storage RDAREAs that constitute the specified index at the specified server.
OmittedThe utility processes all index storage RDAREAs that constitute the index.The utility processes all index storage RDAREAs that constitute the specified index at all servers.
*server-nameNot applicable.The utility processes all index storage RDAREAs that constitute all indexes defined for the table at the specified server.
OmittedThe utility processes all index storage RDAREAs that constitute the index defined for the table.The utility processes all index storage RDAREAs that constitute all indexes defined for the table at all servers.