sp_iqwho Procedure Example

Use the example as a reference for sp_iqwho usage.

Example 1

Display all active connections:
ConnHandle IQConnID Userid ReqType      IQCmdType            BlockedOn BlockUserid IQCursors
IQThreads IQIdle SAIdle TempTableSpaceKB TempWorkSpaceKB

12         118      DBA    CURSOR_OPEN  IQUTILITYOPENCURSOR  0         (NULL)      0  
1         1      0      0             0
13         119      shweta DO_NOTHING   NONE                 0         (NULL)      0
1    16238757   470     0             0
Parent topic: sp_iqwho Procedure