Partition insertion - a Db2 12 greatest hit with John Campbell
Jennie Chang 550000A5PG Visits (4983)
Prior to this enhancement, inserting a new partition into the middle of a table was a complicated process. To do so, you needed to add a new partition at the end of a table space, and then alter the limit key values for multiple partitions to include the new partition value in the intended location. In addition, you needed to run a REORG on every altered partition. This enhancement provides a quick and direct method to insert the new partition and significantly reduces the total amount of data being reorganized.
Moreover, you do not need to manually manage adjacent partitions that could possibly reach their space limits. Once you determine the limit key for the newly inserted partition, the procedure for handling a "partition full" condition can be easily automated by adding the new partition and then running a REORG against the new and adjacent partitions.
A notable aspect of this feature is that you must translate the logical partition numbers into physical partition numbers. The new physical partition is added at the end of the partitioned table space, and the new logical partition is added in the middle. The logical partitions are then renumbered accordingly. Keep this consideration in mind for Db2 utilities, which operate on partition ranges based on physical partition numbers.
With this more straightforward partition insertion process, you can now modify the partition configuration of tables with greater convenience.