Configure In-Memory Row-Level Versioning

Row-level versioning allows multiple transactions to modify different rows of the same table concurrently. In order to utilize the RLV store, several setup steps must first be configured..

1. Configuration Prerequisites
   Before configuring in-memory row level versioning, in addition to the base configuration for SAP Sybase IQ you will need RAM for the RLV store, and a high-performance disk for the RLV dbspace.
2. Configure RLV Memory
   RLV memory is configured in addition to existing IQ cache memory. The host machine must have enough memory for both the RLV memory and the IQ main cache, which are independent memory pools.
3. Configure the RLV Dbspace
   The RLV dbspace houses persistence logs of tables enabled for in-memory RLV storage.
4. Configure RLV Storage on Tables
   A table enabled for RLV storage has two parts: one residing on the IQ main store, and the other residing on the dedicated in-memory RLV Column Store.
5. Configure Snapshot Versioning
   Snapshot versioning describes the type of versioning access that the database server uses for tables: table-level snapshot versioning, or row-level snapshot versioning. Row-level versioning allows concurrent writer access and row-level locking for RLV-enabled tables.
6. Tutorial: Using Row-Level Versioning on a Table
   In this tutorial, create an RLV enabled dbspace and table, insert data, and then merge the RLV store into the IQ main store.