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. For more information, see “sp_iqtransaction procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
