sp_iqmpxinfo Procedure

Returns a row for every node in the multiplex. Can be run from any multiplex node.

Note:

Users with RESOURCE authority are not permitted to execute this stored procedure unless granted EXECUTE permission by a user with DBA authority or by a user with PERMS ADMIN authority.

Syntax

sp_iqmpxinfo

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

The sp_iqmpxinfo procedure returns the following:

sp_iqmpxinfo columns
Column name	Data type	Description
server_id	unsigned int	Identifier for the server for which information appears
server_name	char(128)	Name of the server
connection_info	long varchar	A formatted string containing the host/port portion of the connection string used for TCP/IP connections between multiplex servers.
db_path	long varchar	Full database path
role	char(16)	'coordinator' \| 'writer' \| 'reader'
status	char(8)	'included' \| 'excluded'
mpx_mode	char(16)	'single' \| 'coordinator' \| 'writer' \| 'reader' \| 'unknown'
inc_state	char(16)	'active' \| 'not responding' \| 'timed out'
coordinator_failover	char(128)	Name of the failover server
current_version	unsigned bigint	Decimal-formatted version ID
active_versions	long_varchar	Comma-separated list of decimal formatted version IDs.
private_connection_info	long varchar	A formatted string containing the host/port portion of the connection string used for private TCP/IP connections between multiplex servers
mipc_priv_state	char(16)	'active' – MIPC connection to this node is active over the private interconnect \| 'not responding' – MIPC connection to this node is not responding over private interconnect.
mipc_public_state	char(16)	'active' – MIPC connection to this node is active over the public interconnect. \| 'not responding' – MIPC connection to this node is not responding over public interconnect.

Example

Sample output of sp_iqmpxinfo follows:

server_id,server_name,connection_info,db_path,role,
status,mpx_mode,inc_state,coordinator_failover,
current_version,active_versions,private_connection_
info,mipc_priv_state,mipc_public_state

1,'my_mpx1','host=(fe80::214:4fff:fe45:be26%2):1362
0,(fd77:55d:59d9:329:214:4fff:fe45:be2
6%2):13620,10.18.41.196:13620','/system3/users
/devices/s16900269/iqmpx1/mpx1.db',
'coordinator','included','coordinator','N/A',
'my_mpx2',0,,,'active','active'

2,'IQ_mpx2','host=system3:13625',
'/system3/users/devices/s16900269
/iqmpx_2/wk0001.db','writer','included',
'writer','active','IQ_mpx20', 'not responding','active'

3,'IQ_mpx3,'host=system3:13630/system3/users/devi
ces/s16900269/iqmpx_3/mpx1.db','reader','included',
'unknown',timed out',
'IQ_mpx20','not responding',
'not responding'