Rebalancing data using SQL functions

OpenText™ Analytics Database has three SQL functions for starting and stopping a cluster rebalance. You can call these functions from a script that runs during off-peak hours, rather than manually trigger a rebalance through Administration Tools.

• REBALANCE_CLUSTER rebalances the database cluster synchronously as a session foreground task.

• START_REBALANCE_CLUSTER asynchronously rebalances the database cluster as a background task.

• CANCEL_REBALANCE_CLUSTER stops any rebalance task that is currently in progress or is waiting to execute.