Rebalancing data using the administration tools UI

To rebalance the data in your database:

1. Open the Administration Tools. (See Using the administration tools.)

2. On the Main Menu, select View Database Cluster State to verify that the database is running. If it is not, start it.

3. From the Main Menu, select Advanced Menu and click OK.

4. In the Advanced Menu, select Cluster Management and click OK.

5. In the Cluster Management menu, select Re-balance Data and click OK.

6. Select the database you want to rebalance, and then select OK.

7. Enter the directory for the Database Designer outputs (for example /tmp) and click OK.

8. Accept the proposed K-safety value or provide a new value. Valid values are 0 to 2.

9. Review the message and click Proceed to begin rebalancing data.

   The Database Designer modifies existing projections to rebalance data across all database nodes with the K-safety you provided. A script to rebalance data, which you can run manually at a later time, is also generated and resides in the path you specified; for example /tmp/extend_catalog_rebalance.sql.

   Important

   Rebalancing data can take some time, depending on the number of projections and the amount of data they contain. Vertica recommends that you allow the process to complete. If you must cancel the operation, use Ctrl+C.

   The terminal window notifies you when the rebalancing operation is complete.

10. Press Enter to return to the Administration Tools.