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 host name and port pairs for public domain connections, delimited by semicolons. |
| db_path | LONG VARCHAR NOT NULL | Full path to the database file for the server. |
| private_connection_info | LONG VARCHAR NULL | String containing host name and port pairs for private network connections, delimited by semicolons. |
Constraints on underlying system table: