Merging Table Data from RLV Store with IQ Main Store

Read-write data from a table enabled with row-level versioning (RLV) is housed in the RLV store, and periodically merged automatically with the table's data in the IQ main store. However, you can explicitly merge this RLV-enabled table data from the RLV store with the IQ main store data.

Prerequisites

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported
SAP Sybase IQ 16.0	You must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege

The SAP Sybase IQ resource is authenticated and running.
The RLV store dbspace exists.
The data is stored in a single RLV-enabled table.
Only IQ base tables are supported in the RLV store: catalog, temporary and global temporary tables are not supported.
LONG VARBINARY (LOB) and LONG VARCHAR data types are not supported on RLV-enabled tables.
TEXT and WORD indexes are not supported on RLV-enabled tables.
Foreign key constraints are not supported on RLV-enabled tables or across a combination of RLV-enabled and traditional tables.

Task

An RLV-enabled table uses row-level versioning so multiple writer connections can make simultaneous updates to different rows of the same table.

The RLV store contains all rows of a RLV-enabled table which have been inserted or updated since the last merge.

RLV merge is the process where the latest committed data from the RLV store is written to the IQ main store to create a new main store table-level snapshot version.

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables.
Select an RLV-enabled table from the right pane and either:
- Click the arrow to the right of the name and select Merge RLV, or
- From the Administration Console menu bar, select Resource > Merge RLV.
The menu item is disabled for tables that are not RLV-enabled.
In the Merge RLV dialog, click Yes.