sp_iqtransaction
Transaction information displays, with each row representing a different
transaction:
Name,Userid,TxnID,CmtID,VersionID,State,ConnHandle,IQConnID,MainTableKBCr,MainTableKBDr,TempTableKBCr,TempTableKBDr,TempWorkSpaceKB,TxnCreateTime,CursorCount,SpCount,SpNumber,MPXServerName,GlobalTxnID,VersioningType,Blocking,BlockingTimeout
'SQL_DBC_13cd6038','DBA',1008,0,0,'ACTIVE',3,92,0,0,0,0,0,'2012-08-08 09:00:39.511',0,4,36,,0,'Row-level','True',0
The Blocking value is
True, meaning that connection blocking is enabled
using the BLOCKING database option. Connection blocking means
that when lock contention is detected, the transaction waits (or blocks) for the
conflicting lock to release before requesting the lock again.
The Blocking_Timeout value is 0 (the default value), meaning
the transaction will wait indefinitely for the conflicting lock to release.