Problem: You receive the error message "RLV Store has run out of
memory".
Explanation A
Long running active transaction(s) may be holding RLV store fragments in memory. To
correct, try:
- Running sp_iqrlvmemory stored procedure to determine whether
old RLV store fragments exist.
- Using sp_iqtransaction stored
procedure to locate old active transactions, and terminating them.
Explanation B
Row-level versioned transactions adding or modifying too much data on an RLV-enabled
table will eventually run out of store memory. To correct, try:
- Reducing the update size.
- Reducing the load size.
- Increasing the frequency of commits (to reduce the amount of data modified per
transaction).
Explanation C
Automated merge is not keeping pace with number of RLV transactions. To correct,
try:
- Reviewing the merge history table, SYSIQRLVMERGEHISTORY.
- Adjusting the automated merge period, RV_AUTO_MERGE_EVAL_INTERVAL option.
- Adjusting the automated merge thresholds, RV_MERGE_TABLE_NUMROWS, RV_MERGE_TABLE_MEMPERCENT, and RV_MERGE_NODE_MEMSIZE options.
Explanation D
Maximum RLV memory configured value is too low. To correct, try: