Viewing RLV Memory Usage Statistics

Display the RLV memory usage statistics for the selected SAP Sybase IQ server at a system-wide and per-table levels.

Prerequisites

Database Version	View RLV Memory Usage Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	None.

The SAP Sybase IQ resource is authenticated and running.
The selected resource is a simplex environment.

Note: The RLV Memory Usage Statistics page does not appear on the IQ Node Level Monitor page for individual multiplex nodes.

Task

To write transactions to the RLV store requires a connection with SNAPSHOT_VERSIONING set to row-level. By default, SNAPSHOT_VERSIONING is set to table-level, which writes transactions directly to the IQ store. See Configure Snapshot Versioning in the IQ-product-name Administration: In-Memory RLV Store documentation.

In the Perspective Resources view, select the resource, and select Resource > Monitor Node.
In the left pane of the IQ Node Level Monitor view, select RLV Memory Usage.

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
System-Wide RLV Memory Usage
	RLV Memory Limit	Total amount of RLV memory available, in megabytes.
	RLV Memory Used	Total amount of RLV memory used, in megabytes.
RLV Memory Usage Per Table
	Table Name	Name of each RLV-enabled table.
	Fragments	Number of store fragments for the selected table.
	Total	Total RLV store memory used by the selected table.
	Data	RLV store memory used for the column fragments for the selected table.
	Dictionary	RLV store memory used for the dictionaries for the selected table.
	Bitmap	RLV store memory used to store table-level bitmaps.