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.