Vertica commands

vertica-commands

-- login to vsql
vsql -Ulogin -wpassword

-- number of running processes
ps -ef | grep  -i vertica-udx-R | wc -l

-- list all nodes thet are UP
admintools -t list_allnodes | grep UP

-- restart a node
admintools -t restart_node --hosts 10.1.1.111 -dMY_DB_NAME --force

-- stop a node
admintools -t stop_node --hosts 10.1.1.111

-- start a node
admintools -t start_node --hosts 10.1.1.111

-- start database
admintools -t start_db --database VPA_TEST

-- see cluster state  
admintools -t view_cluster