Nonstop Database, HiRDB Version 9 System Operation Guide
This example reorganizes a row-partitioned table (TABLE1) by RDAREA. The conditions for this reorganization are as follows:
- TABLE1 is row-partitioned in user RDAREAs (RDAREA1 and RDAREA2).
- An index (INDEX1) is defined for TABLE1. INDEX1 is row-partitioned in user RDAREAs (RDAREA3 and RDAREA4).
- The data to be reorganized is the table data in RDAREA1 and the index data in RDAREA3.
- The table is reorganized in the pre-update log acquisition mode (default).
Note: The shaded data will be reorganized.
- Procedure
- Use the pdhold command to shut down the RDAREAs to be reorganized.
- Create a control statements file for the pdrorg command.
- Use the pdrorg command to reorganize the table.
- Back up the RDAREAs that were reorganized.
- Use the pdrels command to release the RDAREAs from shutdown status.
- The procedure step numbers correspond to the paragraph numbers in the explanation that follows. For example, step 3 above is explained in paragraph (3) below.
- Hint
-
- Because you are using the pdrorg command in the pre-update log acquisition mode, you must make a backup after executing the pdrorg command, as described in step 4.
- Because you are using the pdrorg command in the pre-update log acquisition mode, keep the RDAREAs being reorganized in shutdown status from steps 1 through 4.
- Organization of this subsection
- (1) Use the pdhold command to shut down RDAREAs to be reorganized
- (2) Create the control statements file for the pdrorg command
- (3) Use the pdrorg command to reorganize the table
- (4) Back up the RDAREAs that were reorganized
- (5) Use the pdrels command to release RDAREAs from shutdown status
(1) Use the pdhold command to shut down RDAREAs to be reorganized
pdhold -r RDAREA1,RDAREA3
|
(2) Create the control statements file for the pdrorg command
The following are the contents of the control statements file (/pdrorg/rorg01):
(a) HiRDB single server configuration
unload /pdrorg/unfile1 1
idxwork /pdrorg/idxwork 2
sort /sortwork 3
|
- Explanation
- Specifies the name of the unload data file.
- Specifies the name of the directory in which an index information file is to be created. The index information file is created under this directory.
- Specifies the name of the work directory for sorting.
(b) HiRDB parallel server configuration
unload bes1:/pdrorg/unfile1 1
idxwork bes1 /pdrorg/idxwork 2
sort bes1 /sortwork 3
|
- Explanation
- Specifies the name of the unload data file (for bes1).
- Specifies the name of the directory in which an index information file is to be created (for bes1). The index information file is created under this directory.
- Specifies the name of the work directory for sorting (for bes1).
(3) Use the pdrorg command to reorganize the table
pdrorg -k rorg -t TABLE1 -r RDAREA1 /pdrorg/rorg01
|
- Explanation
- Because the index data of INDEX1 stored in RDAREA3 is also to be re-created simultaneously, the -i option is omitted and the index is created in the batch index creation mode.
- -k: Specifies rorg for reorganization.
- -t: Specifies the name of the table that is to be reorganized.
- -r: Specifies the name of the RDAREA in which the table (TABLE1) that is to be reorganized is stored.
- /pdrorg/rorg01: Specifies the name of the control statements file for the pdrorg command created in step (2).
(4) Back up the RDAREAs that were reorganized
(5) Use the pdrels command to release RDAREAs from shutdown status
pdrels -r RDAREA1,RDAREA3
|
We recommend that after the command has executed you check whether the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 9 Command Reference.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.