Determining version using sp_iqstatus output [CR 463635]

To display space that can be reclaimed by dropping connections, use sp_iqstatus and add the results from the two returned rows:

(DBA)> select * from sp_iqstatus() where name like '%Versions:%'
Execution time: 6.25 seconds
Name                 Value
----------------------------
Other Versions: 2 = 1968Mb
Active Txn Versions: 1 = C:2175Mb/D:2850Mb

(First 2 rows) 

The preceding example output shows that one active write transaction created 2175MB and destroyed 2850 MB of data. The total data consumed in transactions and not yet released is 4818MB, or 1968MB + 2850MB = 4818MB.

If sp_iqstatus shows a high percentage of main blocks in use on a multiplex server, run sp_iqversionuse to find out which versions are being used and the amount of space that can be recovered by releasing versions. See sp_iqversionuse in the Sybase IQ Reference Manual.

You can also display version information by using sp_iqtransaction to see total amount of MainTableKBCreated and MainTableKBDropped over transactions. See sp_iqtransaction in the Sybase IQ Reference Manual for details.