{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}