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 buffer cache,
which are independent memory pools.
The maximum size of the RLV store, for all tables, is specified with a
server option, which can be set with:
- The server startup switch -iqrlvmem specifying the <max MB> parameter.
- The sa_server_option system
procedure specifying the rlv_memory_mb, <max MB> parameter
A size of 2 GB or greater is recommended. If the server switch is not specified,
the value defaults to 2 GB.
When defined using either method, if the value exceeds 2/3rds of the system virtual memory limit,
the server generates an error.