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). Figure 13-79 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-79 Example of the database reorganization utility
![[Figure]](figure/zu131390.gif)
(a) Unloading R02
The following is an example of the control statement for unloading R02, as well as the command line:
Control statement (control_file1)
unload /pdrorg/unld01 Command line
pdrorg -k unld -r R02 -W bin -j -t T1 control_file1 |
- Explanation
- -k: Specifies unld for unloading.
- -r: Specifies the name of the RDAREA to be unloaded.
- -W bin: Specifies unloading of data into a format that can be used by the database load utility. This option must be specified.
- -j: Specifies that the table to be unloaded contains an abstract data type that has a BLOB column or LOB attribute.
- -t: Specifies the table identifier of the table to be unloaded.
- control_file1: Specifies the name the control statement file.
(b) Unloading R03
The following is an example of the control statement for unloading R03, as well as the command line:
Control statement (control_file2)
unload /pdrorg/unld02 Command line
pdrorg -k unld -r R03 -W bin -j -t T1 control_file2 |
- Explanation
- -k: Specifies unld for unloading.
- -r: Specifies the name of the RDAREA to be unloaded.
- -W bin: Specifies unloading of data into a format that can be used by the database load utility. This option must be specified.
- -j: Specifies that the table to be unloaded contains an abstract data type that has a BLOB column or LOB attribute.
- -t: Specifies the table identifier of the table to be unloaded.
- control_file2: Specifies the name of the control statement file.
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. Figure 13-80 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-80 Example of the database load utility
![[Figure]](figure/zu131400.gif)
(a) Combining R01 and R02 into R06
The following is an example of the control statement for combining R01 and R02 into R06, as well as the command line:
Control statement (control_file)
option divermsg=off
source R06 /pdrorg/unld01,/pdrorg/unld02 Command line
pdload -W -b T1 control_file |
- Explanation
- -W: Specifies use of a file output by the database reorganization utility as the input file. This option must be specified.
- -b: Specifies that the input file is binary. This must option be specified.
- T1: Specifies the identifier of the target table.
- control_file: Specifies the name of the control statement file.