sp_iqmpxsuspendedconninfo Procedure

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

Syntax

sp_iqmpxsuspendedconninfo

Applies to

Multiplex only.

Privileges

Requires any of the following system privileges to see all suspended connections in the database:

DROP CONNECTION system privilege
MONITOR system privilege
SERVER OPERATOR system privilege

No system privileges are required to see a user's own suspended connections. This procedure is owned by user DBO.

Description

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