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

This example increases the number of row partitions for table TABLE01 from 2 to 3. 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

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

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

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