Nonstop Database, HiRDB Version 9 System Operation Guide
This example reorganizes a table (TABLE1) in which an abstract data type (GEOMETRY or XML type) is defined without the LOB attribute. For an example of reorganizing with an abstract data type (SGMLTEXT type) and the LOB attribute, see 13.3.5 Example 5: Reorganizing a table in which a LOB column is defined. The following are the conditions for this reorganization:
Note: The data indicated by shading is subject to reorganization.
pdhold -r RDAREA1,RDAREA2,RDAREA3,RDAREA4,RDAREA5,RDAREA6 |
The following are the contents of the control statements file (/pdrorg/rorg01):
unload /pdrorg/unfile1 1 idxwork /pdrorg/idxwork 2 sort /sortwork 3 |
unload bes1:/pdrorg/unfile1 1 idxwork bes1 /pdrorg/idxwork 2 sort bes1 /sortwork 3 unload bes2:/pdrorg/unfile2 4 idxwork bes2 /pdrorg/idxwork 5 sort bes2 /sortwork 6 |
pdrorg -k rorg -t TABLE1 /pdrorg/rorg01 |
Back up the RDAREAs that were reorganized (RDAREA1 to RDAREA6). For details about backing up RDAREAs, see 6.4.8 Example 8 (backing up specified RDAREAs).
pdrels -r RDAREA1,RDAREA2,RDAREA3,RDAREA4,RDAREA5,RDAREA6 |
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.