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. |
Constraints on underlying system table:
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.