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:
- Change the boundary between partitions
- Rotate any logical partition to be the last partition
- Extend the boundary of the last partition
- Instruct Db2 to insert rows at the end of a table or appropriate partition
Procedure
To alter a partition:
Issue the ALTER TABLE statement and specify the options
that you want to change.