Redistributing data across database partitions

Redistributing data is a task that you might perform in a partitioned database environment after adding or removing database partitions or when an undesirable proportion of data is appearing on a particular partition so as to rebalance or reconfigure the distribution.

Important:

With the release of Db2® 12.1, the process of redistributing database partition groups using the STEPWISE_REDISTRIBUTE_DBPG procedure is discontinued. Use the REDISTRIBUTE DATABASE PARTITION GROUP command to achieve equivalent functionality.