Transaction Activity Snapshots

The sp_iqtransaction stored procedure displays a snapshot of transaction activity, such as main and temporary space created and in use, open cursors, and savepoints.

It returns a row for each transaction control block in the IQ transaction manager.