13.16.1 Example 1: Migrating data to a table with the same table definition
(1) Use the pdhold command to shut down RDAREAs to be unloaded and RDAREAs to be reloaded
pdhold -r RDAREA01,RDAREA02,... |
(2) Use the pdrorg command to unload data from TABLE01
pdrorg -k unld -j -t TABLE01 -g /pdrorg/unld01 |
- Explanation
- -k: Specifies unld for unloading.
- -j: Specifies that a LOB column or a column with the LOB attribute is defined in the table that is to be unloaded.
- -t: Specifies the name of the table that is to be unloaded.
- -g: Specifies that TABLE01 is row-partitioned between servers in a HiRDB/Parallel Server. Specifying the -g option consolidates the unload data files (into a single file).
- /pdrorg/unld01: Specifies the name of the control statements file for the pdrorg command.
(3) Use the pdrorg command to load data into TABLE02
pdrorg -k reld -j -t TABLE02 -g /pdrorg/reld01 |
- Explanation
- -k: Specifies reld for reloading.
- -j: Specifies that a LOB column or a column with the LOB attribute is defined in the table that is to be reloaded.
- -t: Specifies the name of the table that is to be reloaded.
- -g: If the -g option was specified in step (2), specify it here as well.
- /pdrorg/reld01: Specifies the name of the control statements file for the pdrorg command. Because the data will be reloaded into another table, specify a tblname statement. The following is an example of specifying a tblname statement:
- tblname TABLE01
(4) Back up the RDAREAs in which data was reloaded
Because you reloaded data in the pre-update acquisition mode (default), back up the RDAREAs in which data was reloaded. For details about backing up RDAREAs, see 6.4.6 Example 6 (Backing up RDAREAs).
(5) Use the pdrels command to release RDAREAs from shutdown status
pdrels -r RDAREA01,RDAREA02,... |
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.