The RLV merge executes in five phases.
- Begin – the server performs an auto-commit, begins a new transaction, and prepares for
the merge.
- Delete – the server applies all delete transactions recorded in the IQ
main store. Rows deleted from the RLV store portion of the table are not merged
since they are deleted in-memory. Any committed IQ main store rows deleted prior
to RLV enablement are simply recorded as deleted by the RLV store. The merge
will apply the deletes against the new IQ main store table level version being
created by the merge.
- Update – the server applies all update transactions recorded the IQ main
store. Rows updated from the IQ main store table will store the new values in
the RLV store. The updated new values will be applied to the IQ main store
during the merge.
- Insert – the server transfers the new RLV store inserted rows into the
IQ main store table.
- End – the server completes the merge and commits a new TLV version (or rolls
back).
The merge is logged in the database IQMSG file and the SYSIQMERGERLVHISTORY system view.