The DB_MEMBERS table function returns basic member information about a DB2® pureScale® instance.
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
The function has no input parameters.
$ db2 "select * from table(SYSPROC.DB_MEMBERS()) as members"
MEMBER_NUMBER HOST_NAME PARTITION_NUMBER MEMBER_TYPE
------------- -------------------------------- ---------------- -----------
0 member1.mycompany.com 0 D
1 member2.mycompany.com 0 D
2 member3.mycompany.com 0 D
128 ca1.mycompany.com 0 C
129 ca2.mycompany.com 0 C
PORT_NUMBER SWITCH_NAME STATUS
----------- ------------ ------
0 - -
0 - -
0 - -
0 - -
0 - -
5 record(s) selected.
Column name | Data type | Description |
---|---|---|
MEMBER_NUMBER | SMALLINT | member - Database member monitor element |
HOST_NAME | VARCHAR(256) | host_name - Host name monitor element |
PARTITION_NUMBER | SMALLINT | partition_number - Partition Number monitor element |
MEMBER_TYPE | CHAR(1) | The type of member:
|
PORT_NUMBER | SMALLINT | port_number - Port number |
SWITCH_NAME | VARCHAR(128) | The switch name of the member on the host |
STATUS | SMALLINT | Reserved for future use |