Changing the partitioning storage conditions of a table

You can use ALTER TABLE to change the partitioning storage conditions of tables that have been row-partitioned by key range partitioning.^* Changing the partitioning storage conditions of a table can reduce your workload by enabling you to reuse RDAREAs in which outdated data is stored. ALTER TABLE deletes a table whose partitioning storage conditions are to be changed, eliminating the need to re-create the table.

*

ALTER TABLE can be used to change a table's partitioning storage condition when either of the following partitioning methods was used:

Boundary value specification
Storage condition specification (and the equal sign (=) was used as the comparison operator for the storage condition)

To change the partitioning storage conditions of a table, you must have HiRDB Advanced Partitioning Option.

The following two facilities are provided for changing the partitioning storage conditions of tables.

Organization of this subsection: (1) Split facility; (2) Combine facility

(1) Split facility

The split facility changes the table partitioning storage conditions, splitting data stored in a single RDAREA into multiple RDAREAs. Figure 3-17 provides an example of the split facility (using boundary value specification).

Figure 3-17 Example of the split facility (boundary value specification)

[Figure]

(2) Combine facility

The combine facility changes the table partitioning storage conditions, combining data stored in multiple RDAREAs into a single RDAREA. Figure 3-18 provides an example of the combine facility (using boundary value specification).

Figure 3-18 Example of the combine facility (boundary value specification)

[Figure]

3.3.10 Changing the partitioning storage conditions of a table

(1) Split facility

(2) Combine facility