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.
pdhold -r RDAREA01,RDAREA02,... |
pdrorg -k unld -j -t TABLE01 -g /pdrorg/unld01 |
pdrels -r RDAREA01,RDAREA02,... |
DROP TABLE TABLE01; |
CREATE TABLE TABLE01 ... |
pdhold -r RDAREA01,RDAREA02,... |
pdrorg -k reld -j -t TABLE01 -g /pdrorg/reld01 |
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).
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.