Nonstop Database, HiRDB Version 9 System Operation Guide
The database reorganization utility (pdrorg) must unload data on an RDAREA-by-RDAREA basis and save it in a format that can be used as the input to the database load utility (pdload). The following figure shows an example of the database reorganization utility. In this example, the required unload data files are created before the table's partitioning storage conditions are changed.
Figure 13-85 Example of the database reorganization utility
The following is an example of the control statement for unloading R02, as well as the command line:
unload /pdrorg/unld01 pdrorg -k unld -r R02 -W bin -t T1 control_file1 |
The following is an example of the control statement for unloading R03, as well as the command line:
unload /pdrorg/unld02 pdrorg -k unld -r R03 -W bin -t T1 control_file2 |
The database load utility (pdload) must execute on the unload data files created by the database reorganization utility (pdrorg) on an RDAREA-by-RDAREA basis in the addition mode. The following figure shows an example of the database load utility. In this example, a database is created from a table whose partitioning storage conditions have been changed.
Figure 13-86 Example of the database load utility
The following is an example of the control statement for combining R01 and R02 into R06, as well as the command line:
option divermsg=off source R06 /pdrorg/unld01,/pdrorg/unld02 pdload -W -b T1 control_file |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.