{question}

How do I check whether an SM is Running or Syncing from the database?

{question} 

{answer}

The table system.nodes gather all the information for each node (Storage [SM], Transaction [TE]).

SQL> select * from system.nodes;

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

1 2 41219 10.9.38.229 support.hurley.nuodb.com Running Storage Ready 1 203 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
 2 1 41362 10.9.38.229 support.hurley.nuodb.com Running Transaction Ready 2 330 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
 3 3 33736 10.9.38.229 support.hurley.nuodb.com Running Storage Ready 2 337 DEFAULT_REGION 589824 2.5.5-3-932b3382b5
 4 0 43158 10.9.38.229 support.hurley.nuodb.com Running Transaction Ready 0 0 DEFAULT_REGION 589824 2.5.5-3-932b3382b5

You may find more information on this topic by clicking here.

If you have any questions, please reach out by clicking here. 

{answer}