Question

How can I check whether a SM is Running or Syncing from the database?

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

More information and examples can be found here.