SYS.REBALANCE_ALL_BUCKETS

Rebalance partitioned table data on available SQLFire members.

Syntax

SYS.REBALANCE_ALL_BUCKETS()
Rebalancing is a SQLFire member operation that affects partitioned tables created created in the cluster. Rebalancing performs two tasks:
  1. If the a partitioned table's redundancy setting is not satisfied, rebalancing does what it can to recover redundancy. See Making a Partitioned Table Highly Available.
  2. Rebalancing moves the partitioned table's data buckets between host members as needed to establish the best balance of data across the distributed system.

For efficiency, when starting multiple members, trigger the rebalance a single time, after you have added all members.

Rebalancing Partitioned Data on SQLFire Members provides additional information about the rebalancing operation.

Example

sqlf> call sys.rebalance_all_buckets();