CRC and Sort Order Check

As a superuser, you can run the Index tool on a Vertica database to perform two tasks:

If the database is down, invoke the Index tool from the Linux command line. If the database is up, invoke it as a SQL statement from vsql:

Operation Database Down Database Up

Run CRC

/opt/vertica/bin/vertica ‑D catalog‑path ‑v
select run_index_tool ('checkcrc');
select run_index_tool ('checkcrc', 'true');

Check sort order

/opt/vertica/bin/vertica ‑D catalog‑path ‑I
select run_index_tool ('checksort');
select run_index_tool ('checksort', 'true');

If you run the Index tool in vsql as a SQL statement, you can specify that it analyze all cluster nodes by setting the optional Boolean parameter to true (1). If this parameter is omitted, the Index tool runs only on the current node.

If invoked from the command line, the Index tool runs only on the current node. However, the Index tool can run on multiple nodes simultaneously. Invoke the Index tool binary from the /opt/vertica/bin directory.

Viewing Results

The Index tool writes summary information about its operation to standard output; detailed information on results is logged in one of two locations, depending on the environment where you invoke the tool:

Privileges

Restricted to superusers.