IQ_MPX_INFO system table

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),
	  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 IQ procedures, triggers, and events. SQL Remote automatically replicates changes in this table between servers.

The information in this table only changes:

• when query servers are added or removed from the multiplex

• when a query server replaces the write server

• when 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.