SMAT database columns

There are 42 columns for SMAT DB.

See smat_msgs table columns.

Each bit of columnsBitMask represents whether to query a column:

"1" means querying the column. "0" means no query.

From lowest to highest bit, it represent these columns in sequence:

  • messageContent;dataLen;DestConn;OrigDestConn;DataFmt;SepChars;
  • DriverCtl;UserData;MidDomain;MidHub;MidNum;SrcMidDomain;
  • SrcMidHub;SrcMidNum;Type;SourceConn;OrigSourceConn;Time;Priority;
  • SaveContext;Flags;State;GroupMidDomain;GroupMidHub;GroupMidNum;XltThread;
  • Retries;SkipXlt;UseRecoverDB;GroupID;TimeIn;TimeXlt;TimeOut;
  • TimeQCur;TimeQTot;TimeRec;TimeStor; TimeArc;DBTable;Flags_Resent;
  • Flags_Trace;ErrorString;

Example:

messageContent            0x0000000000000001
dataLen 	                 0x0000000000000002
DestConn	                 0x0000000000000004
DataFmt 	                 0x0000000000000008
SepChars	                 0x0000000000000010
DriverCtl	                0x0000000000000020
UserData	                 0x0000000000000040
....
ErrorString	              0x0000020000000000

To query messageContent, dataLen, and DestConn, the column bit mask is 0x0000000000000007.