Vertica configuration informations

Comments

• Jim_Knicely - Select Field - Administrator

  February 2019 edited February 2019

  Check the file: /opt/vertica/config/admintools.conf

  Plus these system tables are helpful:

  V_CATALOG.DATABASES
  V_MONTOR.SYSTEM
  V_CATALOG.NODES

  1
• salgokrisz

  February 2019

  @Jim_Knicely thank you! But can you tell me if is there another way than checking the tables, because our script should check the type of the DB server even when the databases service is not running.

  0
• SruthiA Vertica Employee Administrator

  February 2019

  /opt/vertica/config/admintools.conf will contain some of the information you requested. node IP's, vertica version, port etc.

  0
• Jim_Knicely - Select Field - Administrator

  February 2019

  Hmm. Didn't I say "Check the file: /opt/vertica/config/admintools.conf"?

  Anyway...

  @salgokrisz, what do you mean by "type of DB server?" Version?

  You can use admintools on the command line to show some useful DB info.

  Examples:

  [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t list_allnodes
   Node             | Host           | State | Version         | DB
  ------------------+----------------+-------+-----------------+-------
   v_mydb_node0001  | 192.168.61.227 | DOWN  | vertica-9.2.0.3 | mydb
   v_mydb_node0002  | 192.168.61.228 | DOWN  | vertica-9.2.0.3 | mydb
   v_mydb_node0003  | 192.168.61.229 | DOWN  | vertica-9.2.0.3 | mydb
   v_test_node0001  | 192.168.61.227 | DOWN  | vertica-9.2.0.3 | test
   v_test_node0002  | 192.168.61.228 | DOWN  | vertica-9.2.0.3 | test
   v_test_node0003  | 192.168.61.229 | DOWN  | vertica-9.2.0.3 | test
   v_up_node0001    | 192.168.61.227 | DOWN  | vertica-9.2.0.3 | up
   v_up_node0002    | 192.168.61.228 | DOWN  | vertica-9.2.0.3 | up
   v_up_node0003    | 192.168.61.229 | DOWN  | vertica-9.2.0.3 | up
   v_vmart_node0001 | 192.168.61.227 | UP    | vertica-9.2.0.3 | vmart
   v_vmart_node0002 | 192.168.61.228 | UP    | vertica-9.2.0.3 | vmart
   v_vmart_node0003 | 192.168.61.229 | UP    | vertica-9.2.0.3 | vmart
   v_wwt_node0001   | 192.168.61.227 | DOWN  | vertica-9.2.0.3 | wwt
   v_wwt_node0002   | 192.168.61.228 | DOWN  | vertica-9.2.0.3 | wwt
   v_wwt_node0003   | 192.168.61.229 | DOWN  | vertica-9.2.0.3 | wwt
  
  [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t db_status -s UP
  vmart
  
  [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t db_status -s DOWN
  test,wwt,mydb,up
  
  [dbadmin@SE-Sandbox-43-node1 ~]$ admintools -t list_node -n v_up_node0001
  Node Information for v_up_node0001
  Symbolic node name:  v_up_node0001
  Host name:  192.168.61.227
  Catalog pathname:  /home/dbadmin
  Data pathname:  /home/dbadmin
  

  0