CRC and Sort Order Check
As a superuser, you can run the Index tool on a Vertica database to perform two tasks:
-
Run a per-block cyclic redundancy check (CRC) on data storage to verify data integrity.
- Check that the sort order in ROS containers is correct.
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 |
---|---|---|
/opt/vertica/bin/vertica ‑D catalog‑path ‑v
|
select run_index_tool ('checkcrc'); |
|
/opt/vertica/bin/vertica ‑D catalog‑path ‑I
|
select run_index_tool ('checksort'); |
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:
- Invoked from the command-line: Results written to
indextool.log
file in the database catalog directory. - Invoked from vsql: Results written to
vertica.log
on the current node.
Privileges
Restricted to superusers.