MEMBERS

A GemFire XD virtual table that contains information about each distributed system member.

See Distributed System Membership Information.
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.
Table 1. MEMBERS system table
Column Name Type Length Nullable Contents
ID VARCHAR 128 No

The unique ID of the member. This ID has the format:

hostname(process_id)<member_number>:udp_port/tcp_port
For example:
10.0.1.31(66878)<v0>:41715/63386
KIND VARCHAR 24 No Specifies the type of GemFire XD member process:
  • datastore—A member that hosts data.
  • peer—A member that does not host data.
  • locator—Provides discovery services for a cluster.
Member types can also be qualified with additional keywords:
  • normal—The member can communicate with other members in a cluster.
  • loner—The member is standalone and cannot communicate with other members. Loners are started with mcast-port=0 and use no locators for discovery.
  • admin—The member also acts as a JMX manager node.
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.
ROLES VARCHAR 128 No Not used.
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.