SYSIQLSMEMBERS Consolidated View

Describes all user-defined logical server memberships.

Column name

Column type

Description

ls_id

UNSIGNED BIGINT NOT NULL

The ID number of the logical server.

ls_name

CHAR(128) NOT NULL

The name of the logical server.

server_id

UNSIGNED INT NOT NULL

The multiplex server identifier of the member, for the membership defined using server name, or 0, for the logical membership of the coordinator.

server_name

CHAR(128) NOT NULL

The multiplex server name of the member for the membership defined using the server name, or 'LOGICAL COORDINATOR' for the logical membership of the coordinator.

membership_type

TINYINT NOT NULL

0 for the membership defined using the server name, or 1 for the logical membership of the coordinator.