SYSIQLSMEMBERS Consolidated System View

Presents logical server membership information from the ISYSIQLSMEMBERS system table in a readable format.

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.