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 above example output shows that 1 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.