How to re-balance data on Vertica using the admintools command line

Using the admintools command line we can create all types of routines and scripts.

  • How to re-balance data on Vertica using the admintools command line:
For this task you need to use the rebalance_data
[dbadmin@bih001 ~]$ admintools -t rebalance_data -d test -p test -k 0

Starting Data Rebalancing tasks.  Please wait....
This process could take a long time; allow it to complete uninterrupted.
Use Ctrl+C if you must cancel the session.

        Data Rebalance completed successfully.
[dbadmin@bih001 ~]$
Where the -d option is followed by the database name, -p password , -k represents the KSAFETY level that we want.