This example increases from 2 to 3 the number of row partitions in table TABLE01. Its index (INDEX01) is partitioned likewise. TABLE01 is FIX hash partitioned.
It is assumed that this table does not use the hash facility for hash row partitioning. When this hash facility is used, an RDAREA can be added with an ALTER TABLE statement even if the table contains data. Consequently, there is no need to unload and reload the table data. For an example of the hash facility for hash row partitioning, see 13.11 Increasing the number of table row partitions (using the hash facility for hash row partitioning).
pdhold -r RDAREA01,RDAREA02,... |
pdrorg -k unld -j -t TABLE01 -g /pdrorg/unld02 |
pdrels -r RDAREA01,RDAREA02,... |
PURGE TABLE TABLE01; |
To increase the number of row partitions in a table with FIX hash partitioning, the data in the table must be deleted.
ALTER TABLE TABLE01 ADD RDAREA RDAREA03; |
pdhold -r RDAREA01,RDAREA02,... |
pdrorg -k reld -j -t TABLE01 -g /pdrorg/reld02 |
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.