For each active member, the server list contains its connectivity and priority information, which enables a remote client to perform workload balancing (WLB) and automatic client reroute (ACR). The member parameter corresponds to the member where the server list is cached.
>>-MON_GET_SERVERLIST--(--member--+-----------------------+--)->< '-,--member_subset_name-'
The schema is SYSPROC.
None
Column name | Data type | Description |
---|---|---|
MEMBER | SMALLINT | member - Database member monitor element |
CACHED_TIMESTAMP | TIMESTAMP | cached_timestamp - Cached timestamp |
HOSTNAME | VARCHAR(255) | hostname - Host name monitor element |
PORT_NUMBER | INTEGER | port_number - Port number |
SSL_PORT_NUMBER | INTEGER | ssl_port_number - SSL port number |
PRIORITY | SMALLINT | priority - Priority value |
MEMBER_SUBSET_ID | INTEGER | member_subset_id - Member subset ID |
SERVER_LIST_ENTRY_MEMBER | SMALLINT | server_list_entry_member - Member ID for the member in the server list |
SELECT MEMBER, CACHED_TIMESTAMP, VARCHAR(HOSTNAME, 30)
AS HOSTNAME, PORT_NUMBER, SSL_PORT_NUMBER, PRIORITY
FROM TABLE (MON_GET_SERVERLIST (-1))
Output results for connection to database SAMPLE on member 0.
MEMBER CACHED_TIMESTAMP HOSTNAME ...
------ -------------------------- -------------------------- ...
0 2011-02-19-17.39.33.000000 coralxib23.torolab.ibm.com ...
0 2011-02-19-17.39.33.000000 coralxib24.torolab.ibm.com ...
Output for query (continued).
... PORT_NUMBER SSL_PORT_NUMBER PRIORITY
... ----------- ---------------- --------------------------
... 49712 0 67
... 49712 0 32
SELECT MEMBER, CACHED_TIMESTAMP, VARCHAR(HOSTNAME, 30)
AS HOSTNAME, PORT_NUMBER, SSL_PORT_NUMBER, PRIORITY
FROM TABLE (MON_GET_SERVERLIST (-2))
MEMBER CACHED_TIMESTAMP HOSTNAME ...
------ -------------------------- -------------------------- ...
0 2011-02-19-17.39.33.000000 coralxib23.torolab.ibm.com ...
0 2011-02-19-17.39.33.000000 coralxib24.torolab.ibm.com ...
1 2011-02-19-17.39.33.000000 coralxib24.torolab.ibm.com ...
1 2011-02-19-17.39.33.000000 coralxib23.torolab.ibm.com ...
Output
for query (continued).... PORT_NUMBER SSL_PORT_NUMBER PRIORITY
... ----------- ---------------- --------------------------
... 49712 0 67
... 49712 0 32
... 49712 0 32
... 49712 0 67
SELECT MEMBER, SUBSET_ID, CACHED_TIMESTAMP, VARCHAR(HOSTNAME, 30)
AS HOSTNAME, PORT_NUMBER, SSL_PORT_NUMBER, PRIORITY
FROM TABLE (MON_GET_SERVERLIST(0, 'MY_SUBSET')
This
query returns the following output: MEMBER SUBSET_ID CACHED_TIMESTAMP HOSTNAME PORT_NUMBER
------ --------- -------------------------- -------------------------- -----------
0 1 2011-02-19-17.39.33.000000 coralxib14.torolab.ibm.com 33163
0 1 2011-02-19-17.39.33.000000 coralxib15.torolab.ibm.com 33163