Use the sp_iqtransaction stored procedure to display a snapshot of transaction activity, such as main and temporary space created and in use, open cursors, and savepoints.
The procedure returns a row for each transaction control block in the IQ transaction manager.