13.10.1 Example 1: Increasing the number of row partitions in a table with key range partitioning

This example increases from 2 to 3 the number of row partitions for table TABLE01. Its index (INDX01) is partitioned likewise. TABLE01 is key-range partitioned.

[Figure]

Organization of this subsection
(1) Use the pdhold command to shut down RDAREAs to be unloaded
(2) Use the pdrorg command to unload data from TABLE01
(3) Use the pdrels command to release RDAREAs from shutdown status
(4) Use the DROP TABLE statement to delete TABLE01
(5) Use the CREATE TABLE and CREATE INDEX statements to redefine TABLE01 and INDEX01, respectively
(6) Use the pdhold command to shut down RDAREAs to be reloaded
(7) Use the pdrorg command to reload data into TABLE01
(8) Back up the RDAREAs in which data was reloaded
(9) Use the pdrels command to release RDAREAs from shutdown status

(1) Use the pdhold command to shut down RDAREAs to be unloaded

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 log data (into a single file).
/pdrorg/unld01: Specifies the name of the control statements file for the pdrorg command.

(3) Use the pdrels command to release RDAREAs from shutdown status

pdrels -r RDAREA01,RDAREA02,...

(4) Use the DROP TABLE statement to delete TABLE01

DROP TABLE TABLE01;

(5) Use the CREATE TABLE and CREATE INDEX statements to redefine TABLE01 and INDEX01, respectively

CREATE TABLE TABLE01 ...
   IN ((RDAREA01),(RDAREA02),(RDAREA03)) ...;
CREATE INDEX INDX01 ...
   IN ((RDAREA11),(RDAREA12),(RDAREA13));

(6) Use the pdhold command to shut down RDAREAs to be reloaded

pdhold -r RDAREA01,RDAREA02,...

(7) Use the pdrorg command to reload data into TABLE01

pdrorg -k reld -j -t TABLE01 -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.

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

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