![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
Required options and control statements depend on the type of index reorganization.
The options listed in (1) and the control statements are mandatory. The items in (2) are related to the options and control statements presented in the Reference column. For details about the options, see subsection 8.9.2.
| Item | Reference | |||
|---|---|---|---|---|
| Option | Control statement | |||
| Type of pdrorg processing | -k ixor | (1) | -- | -- |
| Name of the table subject to index reorganization | -t | (3) | -- | -- |
| File containing the control statements | control-information-filename | (19) | -- | -- |
| Information about the index information file or index | -- | -- | index or idxname statement | 8.9.5 or 8.9.6 |
| Item | Reference location | |||
|---|---|---|---|---|
| Option | Control statement | |||
| Acquiring or not acquiring database update log | -l | (5) | -- | -- |
| Changing the pdrorg executor's user authorization identifier to a value other than the value of environment variable PDUSER#1 | -u | (10) | -- | -- |
| Automatically deleting index information files after index reorganization | -o | (15) | -- | -- |
| Monitoring the response time for server-to-server communication | -X | (17) | -- | -- |
| Not enough space in the /tmp directory when index is reorganized in units of indexes (using the idxname statement) | -- | -- | idxwork statement | 8.9.7 |
| Monitoring the execution time of pdrorg | -- | -- | option statement | 8.9.16 |
| Changing the percentage of free space in index during index reorganization#2 | -- | -- | option statement | 8.9.16 |
| The inner replica facility is used | -q | (18) | -- | -- |
--: Not applicable
#1: If omitted, the system assumes the value of the PDUSER environment variable. If the PDUSER environment variable has not been specified, the system assumes the user name in the login window.
#2: If a space shortage occurs in an RDAREA during execution of pdrorg, you can complete the processing without having to expand the RDAREA temporarily (except for an index whose percentage of free space is 0).
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.