Displays version usage for the IQ main store.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
The sp_iqversionuse system stored procedure helps troubleshoot situations where the databases uses excessive storage space due to multiple table versions.
If out-of-space conditions occur or 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. For information on multiplex capability, see Using Sybase IQ Multiplex.
The amount of space is expressed as a range because the actual amount typically depends on which other versions are released. The actual amount of space released can be anywhere between the values of MinKBRelease and MaxKBRelease. The oldest version always has MinKBRelease equal to MaxKBRelease.
WasReported indicates whether version usage information has been sent from the secondary server to the coordinator. WasReported is 0 initially on a coordinator for new versions. WasReported changes to 1 once SQL Remote replicates version usage information back to the coordinator. If WasReported is 0 for an extended period, SQL Remote might be stopped.
The WasReported column is used in a multiplex setting. For more information on multiplex, see Using Sybase IQ Multiplex.
You can use this procedure in a multiplex environment. See Using Sybase IQ Multiplex.
Column name |
Description |
|---|---|
VersionID |
In simplex databases, the VersionID is displayed as zero. For the multiplex coordinator, the VersionID is the same as the TxnID of the active transaction and VersionID is the same as the CmtID of a committed transaction. In multiplex secondary servers, the VersionID is the CmtID of the transaction that created the database version on the multiplex coordinator. It is used internally by the Sybase IQ in-memory catalog and the IQ transaction manager to uniquely identify a database version to all nodes within a multiplex database. |
Server |
The server to which users of this version are connected |
IQConnID |
The connection ID using this version |
WasReported |
Indicates whether the server has received usage information for this version |
MinKBRelease |
The minimum amount of space returned once this version is no longer in use |
MaxKBRelease |
The maximum amount of space returned once this version is no longer in use |