This example increases from 2 to 3 the number of row partitions in rebalancing table TABLE01. Its index (INDX01) is partitioned likewise.
pdfmkfs -n 50 -l 10 -k DB -i /rdarea/area03 |
pdmod -a /pdmod/create01 |
create rdarea RDAREA03 |
ALTER TABLE TABLE01 |
An RDAREA for storing table data (RDAREA03) and an RDAREA for storing indexes (RDAREA13) have been added. The number of row partitions in TABLE01 has now been increased from 2 to 3.
pdrbal -k share -t TABLE01 -c 100 /pdrbal/cfile01 |
report /tmp/output |
pdrbal -k exclusive -t TABLE01 -l a /pdrbal/cfile01 |
report /tmp/output |
If necessary, use the optimizing information collection utility (pdgetcst command) to collect optimization information for the table. For details about whether or not execution of the optimizing information collection utility is required, see the manual HiRDB Version 8 Command Reference.
pdgetcst -t TABLE01 -l /pdgetcst/output |
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.