CREATE TABLE "DBA".IQ_MPX_INFO ( id numeric(8,0) IDENTITY NOT NULL, server_name varchar(30) NOT NULL, host_name varchar(40) NOT NULL, port_number numeric(8,0)NOT NULL, db_path varchar(1024) NOT NULL, role char(1) NOT NULL, node_status varchar(10) NOT NULL, remote_user varchar(40) NOT NULL, PRIMARY KEY (id), UNIQUE (server_name) )IN SYSTEM;
Each row in this table contains information about a particular server in a multiplex. The table contains only one row per server.
Sybase Central uses the information in this table to manage the multiplex. The information is also used internally in the Sybase IQ procedures, triggers, and events. SQL Remote automatically replicates changes in this table between servers.
The information in this table changes only when:
Query servers are added or removed from the multiplex
A query server replaces the write server
Query servers are excluded from or included in the multiplex environment
UPDATE permission is not granted to PUBLIC.
SQL Remote automatically replicates changes in this table between multiplex servers.
id The sequence number of this server.
server_name The server name of this server.
host_name The host on which this server runs.
port_number The TCP port number on which to start this server.
db_path The full path to the Catalog Store (.db file) for this server. Each server’s database files must be placed on a file system local to its node. Each server may use a different name for its catalog database file (and database name).
role Write server ('W') or query server ('R').
node_status Server is Active or Inactive.
remote_user The remote user ID for SQL Remote replication at this server.
