13.10.2 Example 2: Increasing the number of row partitions in a table with flexible hash partitioning

This example increases from 2 to 3 the number of row partitions for table TABLE01. Its index (INDEX01) is partitioned likewise. TABLE01 is flexible hash partitioned.

It is assumed that this table does not use the hash facility for hash row partitioning.

[Figure]

Organization of this subsection
(1) Use the ALTER TABLE statement to add RDAREA03 to TABLE01

(1) Use the ALTER TABLE statement to add RDAREA03 to TABLE01

ALTER TABLE TABLE01 ADD RDAREA RDAREA03;

In this step, no data is stored in RDAREA03. Data that will be added subsequently will be stored using a hash function.

When the hash facility for hash row partitioning is used, data will be stored in RDAREA03, and this will prevent an imbalance in the amount of data stored in the existing RDAREAs and in the newly added RDAREA. 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).