sp_iqconnection
You see:
ConnHandle,Name,Userid,LastReqTime,ReqType,IQCmdType,LastIQCmdTime,IQCursors,LowestIQCursorState,IQthreads,TxnID,ConnCreateTime,TempTableSpaceKB,TempWorkSpaceKB,IQconnID,satoiq_count,iqtosa_count,CommLink,NodeAddr,LastIdle,MPXServerName,LSName,INCConnName,INCConnSuspended
1,'SQL_DBC_13de5fd8','DBA','2012-08-08 08:49:25.629','PREFETCH','NONE',2012-08-08 08:49:25.0,0,'NONE',0,0,2012-08-08 08:49:24.0,0,0,70,40,2,'local','',0,,,'','N'
3,'SQL_DBC_13cd6038','DBA','2012-08-08 09:25:32.920','OPEN','IQUTILITYOPENCURSOR',2012-08-08 09:25:32.0,0,'NONE',0,1008,2012-08-08 08:50:04.0,0,0,92,187,413,'local','',8789,,,'','N'
1000000407,'INT: RLVLockConn','','','unknown (0)','NONE',0001-01-01 00:00:00.0,0,'NONE',0,0,2012-08-08 09:00:40.0,0,0,410,2,0,'NA','NA',0,,,'','N'