Using the Administration Tools

Vertica provides a set of tools that allows you to perform administrative tasks quickly and easily. Most of the database administration tasks in Vertica can be done using the Administration Tools. If your administrative tasks go beyond those provided by the tools, contact Technical Support for information.

Always run the Administration Tools using the Database Administrator account on the Administration Host if possible. Make sure that no other Administration Tools processes are running.

If the Administration Host is down, run the Administration Tools on a different node in the cluster. That node permanently takes over the role of Administration Host.

Running the Administration Tools

At the Linux command line:

$ /opt/vertica/bin/adminTools [ -t | --tool ] toolname [ options ]

If you omit the toolname and options, the Main Menu dialog box appears inside your console or terminal window with a dark blue background and a title on top. The screen captures used in this documentation set are cropped down to the dialog box itself, as shown below.

If you are unfamiliar with this type of graphical user interface, read Using the Graphical User Interface before you do anything else.

First Time Only

The first time you log in as the Database Administrator and run the Administration Tools, the user interface displays:

1. the EULA (license agreement). Type accept to proceed.
2. a form asking for the pathname to the license key file that you downloaded from the Vertica Web site. The default pathname is /tmp/vlicense.key. If this is correct, press OK. Otherwise, enter the absolute pathname of the file and press OK.

   

   

Between Dialogs

While the Administration Tools are working, you will see the command line processing in a window similar to the one shown below. Do not interrupt the processing.