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.