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:

The process of redistributing database partition groups using the STEPWISE_REDISTRIBUTE_DBPG procedure is deprecated for Db2® version 11.5.8 and will be discontinued in a future release or modification pack. Use the REDISTRIBUTE DATABASE PARTITION GROUP command to achieve equivalent functionality.