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)
