Returns a row for every node in the multiplex. Can be run from any multiplex node.
Multiplex only.
The sp_iqmpxinfo procedure returns:
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. |
Sample output of sp_iqmpxinfo :
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'