sp_iqmpxinfo procedure

Function

If run on the coordinator node, displays complete multiplex configuration info for all nodes. If run on a secondary node, displays complete multiplex configuration info for only that node.

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 in order to run the stored procedure.

Description

The sp_iqmpxinfo procedure returns the following:

**Table A-5: sp_iqmpxinfo columns**
Column name	Data type	Description
server_id	unsigned int	Identifier for the server for which information is displayed
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 TCPIP 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' \| 'writer' \| '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.

Example

This example shows 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

1,'dbsrv10261_c1','host=(fe80::214:4fff:fe45:
e6f2%2):11075,(fd77:55d:59d9:329:214:4fff:fe45:
e6f2%2):11075,10.18.41.194:11075',
'/sunx5prod/mpxsim/c1/mpx_simdb.db',
'coordinator','included','coordinator',
'N/A','r2_dbsrv10261',0,

2,'r2_dbsrv10261','host=localhost:7733',
'/sunx5prod/mpxsim/r2/mpx_simdb.db',
'reader','included','reader','active',
'r2_dbsrv10261',0,

3,'w3_dbsrv10261','host=localhost:5507',
'/sunx5prod/mpxsim/w3/mpx_simdb.db','writer',
'included','writer','active','r2_dbsrv10261',0,