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

(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

(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.