Active Cluster Guide > Active Cluster SYS_CLUSTER System Table
 
Active Cluster SYS_CLUSTER System Table
The Studio resource tree displays the metadata stored as a set of system tables in a database called System. The system database tables are visible to all client applications that have the appropriate access privileges.
Studio users can only execute SQL SELECT statements on the system tables. They cannot change system table data (because changes could compromise performance).
The SYS_CLUSTER table provides the status of the Active Cluster to which this server belongs. Each cluster system has one row, including a row for the server to which you are connected, although the contact information is NULL for this server. You must have ACCESS_TOOLS and READ_ALL_STATUS rights to see the rows in the table.
The following table describes the schema for the SYS_CLUSTER table.
Column
TDV
JDBC Data Type
Nullable
Description
SERVER_ID
VARCHAR (255)
 
Server ID.
SERVER_NAME
VARCHAR (255)
 
Server name.
SERVER_HOST
VARCHAR (255)
 
Server hostname.
SERVER_PORT
INTEGER
 
Server port.
STATUS
VARCHAR (20)
 
Server status.
TIMEKEEPER
CHAR (1)
 
Y if the server is the timekeeper, otherwise N.
CONNECT_TIME
TIMESTAMP
Yes
The time the cluster connection was established by this server. Each time the server connects to a cluster node and becomes an active member of the cluster, this value is updated.
LAST_CONTACT
TIMESTAMP
Yes
The last time this server received a message across the cluster network connection.
IDLE_DURATION
BIGINT
 
Number of milliseconds since LAST_CONTACT.
NUM_CONNECTS
BIGINT
 
Number of times this server successfully connected to the cluster.
BYTES_TO
BIGINT
 
Number of bytes sent to this server since it started.
BYTES_FROM
BIGINT
 
Number of bytes sent from the remote server to this server.
MESSAGE
VARCHAR (65535)
Yes
Additional information about the server.