Viewing Table Version Statistics

Display the table version statistics for the selected SAP Sybase IQ server.

In the Perspective Resources window, select the resource, click the arrow, and select Monitor Node.
In the left pane of the IQ Node Level Monitor view, select Table Versions.

Note: To display the information in a chart or table in the full window, select the Maximize icon in the top right of the area.

Area	Description
Statistics	Number of committed versions – the number of table versions in the server. Total version space used (MB) – total space consumed by all the table versions. Oldest version ID – the oldest version identifier on the server. Number of active versions – total number of active write table versions on the server. Total active version space created (MB) – amount of data created by active write transactions. Total active version space to be destroyed (MB) – amount of data destroyed by active write transactions. If these transactions commit, the destroyed data becomes an old version and is eventually dropped. If the transactions roll back, the created data is released.
Table versions	Version ID – the table version identifier. Server name – the name of the server. Connection ID – the connection ID using this table 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. WasReported – indicates whether the server has received usage information for this version.

Area

Description

Statistics

Number of committed versions – the number of table versions in the server.

Total version space used (MB) – total space consumed by all the table versions.

Oldest version ID – the oldest version identifier on the server.

Number of active versions – total number of active write table versions on the server.

Total active version space created (MB) – amount of data created by active write transactions.

Total active version space to be destroyed (MB) – amount of data destroyed by active write transactions. If these transactions commit, the destroyed data becomes an old version and is eventually dropped. If the transactions roll back, the created data is released.

Table versions

Version ID – the table version identifier.

Server name – the name of the server.

Connection ID – the connection ID using this table 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.

WasReported – indicates whether the server has received usage information for this version.