Display the table version statistics for the selected
SAP Sybase IQ server.
- In the Perspective Resources view, select the resource, and select .
- In the left pane of the IQ Node Level Monitor view, select Table Versions.
Note:
-
Click a column header to sort the data by that column.
-
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.
|