Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Recover for Db2 13.1.

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


The following figure shows the phases that are used when you use:

  • 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.

Phases used for table space recovery with multiple log sorts and parallel index sorts with multitasking index rebuilds

GUID-E676BEB1-66BA-4C32-8A24-B001894271E3-low.png


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*