Start of change

Ability to add partitions between existing logical partitions

Db2 12 introduces the ability to add partitions between existing logical partitions in partition-by-range table spaces.

Adding a partition between existing logical partitions is supported only for partition-by-range (UTS) table spaces. The new partition is the next physical partition not being used until the maximum for the table space has been reached. A partition added between existing logical partitions is a pending definition change if the data sets are already defined. Otherwise, the change is immediate.

End of change