sp_iqmpxsuspendedconninfo Procedure

Shows details about currently suspended connections and transactions on the coordinator node.

Syntax

sp_iqmpxsuspendedconninfo

Applies to

Multiplex only.

Privileges

You must have EXECUTE privilege on the system procedure. No system privilege is needed to see your own suspended connections. You must also have one of the following system privileges to see all suspended connections in the database:

DROP CONNECTION
MONITOR
SERVER OPERATOR

Remarks

Returns:

sp_iqmpxsuspendedconninfo Columns
Column Name	Data Type	Description
ConnName	char(128)	Connection name
ConnHandle	unsigned integer	Connection identifier
GlobalTxnID	unsigned bigint	Global transaction identifier of active transaction on this connection
MPXServerName	char(128)	Name of the multiplex server where the INC connection originates
TimeInSuspendedState	integer	Total time, in seconds, spent by the connection in suspended state
SuspendTimeout	integer	Suspend timeout, in seconds (2*MPX_LIVENESS_TIMEOUT)

Example

sp_iqmpxsuspendedconninfo

ConnName             ConnHandle      GlobalTxnId
===================  =============   =============
'IQ_MPX_SERVER_P54'             14          112753 

MPXServerName        TimeInSuspendedState
==================   =======================
'HP1_12356_IQ_mpx2'                       37

SuspendTimeout
===============
            360