Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Using admintools to List Nodes for a Particular Database

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:
[[email protected] ~]$ 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:
[[email protected] ~]$ 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/9.1.x/HTML/index.htm#Authoring/ConceptsGuide/Components/TheAdministrationTools.htm
Have fun!
0
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Is it known what the cause is that made the version 'unavailable' on the following line when it was stated in all other nodes?
v_test_4_nodes_node0004 | 192.168.2.203 | DOWN | unavailable | test_4_nodes