Reclaiming Resources Held for Global Transactions

If a writer node with one or more active global transactions becomes inaccessible, the coordinator does not immediately release resources held for global transactions.

The coordinator waits for a period of 2 * Mpx_Liveness_Timeout for the writer to resume the global transaction. If the writer does not resume by the end of the period, the coordinator releases resources. To free the resources held for the global transactions immediately, kill the corresponding suspended INC connections on the coordinator.

Run the stored procedure sp_iqmpxsuspendedconninfo to locate the suspended connection:

call sp_iqmpxsuspendedconninfo

ConnName             ConnHandle      GlobalTxnId
===================  =============   =============
'IQ_MPX_SERVER_P5'              15            3920 

MPXServerName        TimeInSuspendedState
==================   =======================
'HP1_12356_IQ_mpx'                        50

SuspendTimeout
===============
           7200

On the server specified in MPXServerName, issue a drop command that specifies the ConnHandle for the connection:
```
call "DROP CONNECTION 15"
```