Presents group information from the ISYSIQLSMEMBER table, which stores logical server membership information.
ISYSIQLSMEMBER stores the logical servers and their corresponding multiplex servers.
Column name |
Column type |
Description |
|---|---|---|
ls_id |
UNSIGNED BIGINT NOT NULL |
The ID number of the logical server. |
logical_membership_type |
TINYNT NOT NULL |
The type of the logical membership. |
mpx_server_id |
UNSIGNED INT NOT NULL |
The ID number of the multiplex server. |
membership_info |
UNSIGNED INT NOT NULL |
The membership information. |
Primary key(ls_id, logical_membership_id, mpx_server_id)
ls_id foreign key(ISYSIQLOGICALSERVER)
For logical server memberships that are defined using the multiplex server name, the value of logical_membership_type is 0 and mpx_server_id is the server id of the multiplex server.
For the logical membership of the coordinator, mpx_server_id is 0 and logical_membership_type is 1.