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

12         118      DBA    CURSOR_OPEN  IQUTILITYOPENCURSOR  0         (NULL)      0  
13         119      shweta DO_NOTHING   NONE                 0         (NULL)      0


IQThreads IQIdle   SAIdle TempTableSpaceKB TempWorkSpaceKB
1         1          0       0             0
1         16238757   470     0             0
Parent topic: sp_iqwho Procedure