12.3.3 idxname statement (specification of index information)

When index pages are to be read into the global buffer (-k index), the idxname statement specifies information about the target index.

Criteria
When -k index is specified, the utility processes all indexes defined for the table that is specified with the -t option. You specify the idxname statement to read only a particular index, server, or RDAREA.
Rules
  1. Specify the name operand before the server and rdarea operands.
  2. Enclose an identifier in double quotation marks (") if it contains any spaces or lowercase letters. Lowercase letters are treated as uppercase letters, if not enclosed in double quotation marks.
  3. Once you specify an idxname statement with the rdarea operand specified, you cannot specify another idxname statement specifying only the name operand or an idxname statement specifying the server operand.
  4. You cannot specify more than one idxname statement specifying the same index identifier, except when the rdarea operand is specified.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

 idxname name={index-identifier|*}

         [{server=server-name[,server-name]...

             |rdarea=RDAREA-name[,RDAREA-name]...}]

(2) Explanation

(a) name={index-identifier|*}
index-identifier ~<identifier>
Specifies the identifier of the index that is to be read into the global buffer.
There is no need to specify the authorization identifier, because the utility assumes the authorization identifier of the table specified with the -t option.
An asterisk (*) specifies that all indexes defined for the table are to be read.
The system reads all indexes for the table both when the idxname statement specifying * (without the server operand) is specified and when the idxname statement is omitted. If you specify the idxname statement specifying both * and the server operand, the utility reads only those indexes located at the back-end server specified in the server operand.
When * is specified, there can be only one idxname statement.
(b) server=server-name[,server-name]...

~<identifier>

This operand is applicable to a HiRDB parallel server configuration only.

Specifies the name of the server (back-end server name) when only the portion of the index specified in the name operand that is located at the specified server is to be processed. When this operand is omitted, the utility assumes all servers that contain the index.

In the case of a shared index, the utility performs processing at the updatable back-end server and all reference-only back-end servers regardless of this operand's specification.

(c) rdarea=RDAREA-name[,RDAREA-name]...

~<identifier>

Used to target specific index RDAREAs, this operand specifies the names of RDAREAs for the index that is specified in the name operand. When this option is omitted, the utility assumes all RDAREAs that store the index.

If * is specified in the name operand, this operand cannot be specified.