The idxname statement specifies information about an index to be re-created or reorganized.
idxname name=index-identifier [server=server-name[,server-name]...] |
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.
~<identifier> ((1-8))
For a HiRDB parallel server configuration, 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.
The following table shows the relationship among the name operand, server operand, and execution environment:
name operand | server operand | Execution environment | |
---|---|---|---|
HiRDB single server configuration | HiRDB parallel server configuration | ||
index- identifier | server-name | Not applicable. | The utility processes all index storage RDAREAs that constitute the specified index at the specified server. |
Omitted | The 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-name | Not applicable. | The utility processes all index storage RDAREAs that constitute all indexes defined for the table at the specified server. |
Omitted | The 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. |