Viewing Merge History

View a list of merges which took place on a specific table, including information on merge date, merge type, and merge statistics.

Prerequisites
Task
  1. Use the SYSIQMERGERLVHISTORY view to see when the merge occurred, what data was merged, and why.
  2. Look at the IQMSG file to see logged merge failures.
Related concepts
Automated Foreground Merge
Logged Merge Phases in IQMSG File
Post-Merge Table Fragments
Related tasks
Setting Merge Trigger Thresholds
Running a Manual Merge
Related reference
SYSIQRLVMERGEHISTORY System View