11.3.3 idxname statement (specification of index information)

The idxname statement specifies information about an index from which used free pages are to be released (-k 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 process 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[Figure]<identifier>
Specifies the identifier of the index whose used free pages are to be released.
There is no need to specify the authorization identifier, because the utility assumes the authorization identifier of the table specified with the -t option.
* Specifies that used free pages are to be released from all indexes defined for the table.
The system processes 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 processes 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]...

[Figure]<identifier>

This operand is applicable to a HiRDB/Parallel Server only. Specifies the name of the server (back-end server name) when only the part 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.

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

[Figure]<identifier>

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. This operand cannot be specified when an asterisk (*) is specified in the name operand.