VERTICA – Check Node Status

  By ,

Below is a query to monitor the Node status in Vertica. a node in the DOWN state does not participate in any transactions committed after the time the node came down.

SELECT node_name, node_state FROM nodes ORDER BY 1; 

Cheers!

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. VERTICA – View the Number of ROS Containers Per Projection Per Mode
  2. VERTICA – View Cluster Status
  3. Vertica – Check System Resources
  4. VERTICA – Introduction to Projections
Tagged  , , , , , , , , , , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *