|GemFire XD Reference / System Tables|
A GemFire XD virtual table that contains information about each distributed system member.
The unique ID of the member. This ID has the format:
|KIND||VARCHAR||24||No||Specifies the type of GemFire XD member process:
Member types can also be qualified with additional keywords:
|HOSTDATA||BOOLEAN||Yes||A value of '1' indicates that this member is a data store and can host data. Otherwise, the member is a peer client with no hosted data.|
|ISELDER||BOOLEAN||No||Is this the eldest member of the distributed system. Typically, this is the member who first joins the cluster.|
|IPADDRESS||VARCHAR||64||Yes||The fully-qualified hostname/IP address of the member.|
|HOST||VARCHAR||128||Yes||The fully-qualified hostname of the member.|
|PID||INTEGER||10||No||The member process ID.|
|PORT||INTEGER||10||No||The member UDP port.|
|NETSERVERS||VARCHAR||32672||No||Host and port information for Network Servers that are running on GemFire XD members.|
|LOCATOR||VARCHAR||32672||No||Host and port information for locator members.|
|SERVERGROUPS||VARCHAR||32672||No||A comma-separated list of server groups of which this member is a part.
Note: GemFire XD converts server group names to all-uppercase letters before storing the values in the SYS.MEMBERS table. DDL statements and procedures automatically convert any supplied server group values to all-uppercase letters. However, you must specify uppercase values for server groups when you directly query the SYS.MEMBERS table.
|SYSTEMPROPS||CLOB||2147483647||No||A list of all system properties used to start this member. This includes properties such as the classpath, JVM version, and so forth.|
|GEMFIREPROPS||CLOB||2147483647||No||The names and values of GemFire core system properties that the member uses. See Configuration Properties for property descriptions.|
|BOOTPROPS||CLOB||2147483647||No||All of the GemFire XD boot properties names and values that a member uses. See Configuration Properties for property descriptions.|