Multiple log sorts, MERGE phases, and parallel index key sorts with multitasking index rebuilds

• The MAXLSORT option to specify multiple log sorts and parallel MERGE phases

• The KSORTSHARE option to indicate that each MERGE phase has its own set of key sorts

• The MAXKSORT option to specify that index key sorts are to run in parallel and that index rebuilds are multitasked

BMC AMI Recover schedules concurrent log sorts and MERGE phases for the table spaces. The indexes for each table space are handled as in Parallel index key sorts and multitasking index rebuilds, except that the total number of BUILD phases and index key sorts that can run concurrently is equal to the value of MAXKSORT * MAXLSORT.

BMC AMI Recover chooses the most efficient strategy to reduce sort times and the number of bytes that are sorted.

Sort tasks are shown as shaded boxes in the background.