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.

NoteUsers 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,