This example reorganizes a table (TABLE1) in which is defined an abstract data type (GEOMETRY or FILELINK type) 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 |
unload bes1:/pdrorg/unfile1 1 |
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.6 Example 6 (Backing up RDAREAs).
pdrels -r RDAREA1,RDAREA2,RDAREA3,RDAREA4,RDAREA5,RDAREA6 |
It is recommended that after the command has executed you check whether or not the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 8 Command Reference.