SYSIQMPXSERVER system view

Presents a readable version of the table ISYSIQMPXSERVER. The ISYSIQMPXSERVER system table stores membership properties and version status data for the given multiplex node.

Column name

Column type

Description

server_id

UNSIGNED INT NOT NULL

The ID number of the server.

server_name

CHAR(128) NOT NULL

The server name. Must be case insensitive unique.

role

TINYINT NOT NULL

Coordinator, reader, or writer.

status

TINYINT NOT NULL

Excluded or included.

current_version

UNSIGNED BIGINT NULL

Current version ID of the server.

active_version

LONG BINARY NULL

The list of active versions on the server (encoded).

connection_info

LONG VARCHAR NULL

String containing hostname and port pairs delimited by semicolons.

db_path

LONG VARCHAR NOT NULL

Full path to the database file for the server.

Constraints on underlying system table Primary key(server_id)