
The Vertica Administration tools allow you to easily perform administrative tasks, such as quickly viewing information and statuses of all database nodes via the list_allnodes tool.
Example:
[dbadmin@vertica01 ~]$ admintools -t list_allnodes
Node | Host | State | Version | DB
-------------------------+---------------+-------+-----------------+--------------
v_port_5432_node0001 | 192.168.2.200 | DOWN | vertica-9.1.1.1 | port_5432
v_port_5435_node0001 | 192.168.2.200 | DOWN | vertica-9.1.1.1 | port_5435
v_rename_me_node0001 | 192.168.2.200 | DOWN | vertica-9.1.1.1 | rename_me
v_rename_me_node0002 | 192.168.2.201 | DOWN | vertica-9.1.1.1 | rename_me
v_rename_me_node0003 | 192.168.2.202 | DOWN | vertica-9.1.1.1 | rename_me
v_sfdc_node0001 | 192.168.2.200 | DOWN | vertica-9.1.1.1 | sfdc
v_test_4_nodes_node0001 | 192.168.2.200 | DOWN | vertica-9.1.1.1 | test_4_nodes
v_test_4_nodes_node0002 | 192.168.2.201 | DOWN | vertica-9.1.1.1 | test_4_nodes
v_test_4_nodes_node0003 | 192.168.2.202 | DOWN | vertica-9.1.1.1 | test_4_nodes
v_test_4_nodes_node0004 | 192.168.2.203 | DOWN | unavailable | test_4_nodes
v_test_db_node0001 | 192.168.2.200 | UP | vertica-9.1.1.1 | test_db
v_test_db_node0002 | 192.168.2.201 | UP | vertica-9.1.1.1 | test_db
v_test_db_node0003 | 192.168.2.202 | UP | vertica-9.1.1.1 | test_db
If I only want to see the IP addresses and states of the nodes from a particular database, I could combine the Linux grep and awk commands to limit the output of admintools like so:
[dbadmin@vertica01 ~]$ admintools -t list_allnodes | grep test_db | awk '{print $1,$3,$5}'
v_test_db_node0001 192.168.2.200 UP
v_test_db_node0002 192.168.2.201 UP
v_test_db_node0003 192.168.2.202 UP
Helpful link:https://my.vertica.com/docs/latest/HTML/index.htm#Authoring/ConceptsGuide/Components/TheAdministrationTools.htm
Have fun!