Using admintools to List Nodes for a Particular Database: Quick Tip

Jim Knicely authored this post.

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!