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.

Balance the memory size with the merge frequency. Although a smaller in-memory allocation may be sufficient if you anticipate frequent transactions, consider that the smaller in-memory size may affect the frequency of RLV store merges, thus impacting overall performance.

• For batch loads use at least twice the maximum single-transaction load data size, per table.
• For continuous/OLTP loads, the size depends on incoming data and transaction rate.

For the RLV Log dbspace, disk requirements include:

• A minimum of two times the RLV in-memory size.
• High random access write performance, enterprise SSD and HBA attached disk array.