Displaying information about transactions

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” on page 669 in the Sybase IQ Reference Manual.