DB and TE connection

 

{question}

From client connection to the database, how can I check which TE I am connected to? 

{question}

 

{answer}

In case of a multiple TEs system, a connection to the database using nuosql process will choose the current available TE randomly.

To get the information for the currently connecting TE:                                                                                                       

$ .opt/nuodb/bin/nuosql <db_name> --user <db_user> --password <db_password>
SQL> select * from system.nodes where localid = 0;                                                                                                                     

ID  LOCALID  PORT   ADDRESS   HOSTNAME   STATE     TYPE     CONNSTATE  MSGQSIZE  TRIPTIME  GEOREGION  PLATFORM_VER     RELEASE_VER     

--- -------- ----- ---------- --------- ------- ----------- ---------- --------- --------- ---------- ------------- ------------------
  2     0     48007 172.17.0.4 localhost Running Transaction   Ready        0         0         0         1245184    3.4.2-2-44245c06ec

 

From this example, we are currently connected to ID=2.

 

More information can be found here

{answer}

Have more questions? Submit a request

Comments