Altering partitions

You can use the ALTER TABLE statement to alter the partitions of table spaces.

About this task

You can make the following changes:

To alter a partition:

Issue the ALTER TABLE statement and specify the options that you want to change.

Changing the boundary between partitions
You can change the boundary of a partition by explicitly specifying a new value for the limit key. The limit key is the highest value of the partitioning key for a partition. The partitioning key is the column or columns that are used to determine the partitions.
Rotating partitions
You can use the ALTER TABLE statement to rotate any logical partition to become the last partition. Rotating partitions is supported for partitioned (non-universal) table spaces and range-partitioned table spaces, but not for partition-by-growth table spaces.
Extending the boundary of the last partition
You can extend the boundary of the last partition of a table that uses table-controlled partitioning without impacting data availability.
Splitting the last partition into two
To allow for future growth, you can truncate the last partition of a table space and move some of the data into a new partition.
Inserting rows at the end of a partition
To specify how you want DB2 to insert rows at the end of a partition, you can use the CREATE TABLE or ALTER TABLE statement.

Parent topic: Altering DB2 tables