We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


List sessions not using load balance — Vertica Forum

List sessions not using load balance

Hi,

 

I would like to know is there a way to list all the sessions with load balancing while connecting to the cluster.

 

We are using "Native Load Balancing". Its really hard to go to each and every client machine and check the login screens or DB Visualizer settings to judge.

 

So please let me know if there is a way to find this.

 

Thanks

Kumar

 

Comments

  •  There is no way to identify how the connection is done from the point of LB type. 

    I suggest you use a session label names so ou can identify the session connection type.

     

     

  • Hi Adrian,

     

    Thanks for the response and taking time to review my request.

    Yes we did check the session connection type but it only says whether its a jdbc, MC ...

    But that is nothing related to LB type.

     

    With your answer, atleast now i am confident that there is no paramter to specify the LB type.

     

    Thanks

    Kumar

     

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.