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.

Parallel index key sorts and multitasking index rebuilds


The following figure shows the phases that are used when you use the MAXKSORT option to specify that index key sorts are to run in parallel and that index rebuilds are multitasked.

In this example, MAXLSORT is set to 1 so that multiple log sorts and parallel MERGE phases are not used and KSORTSHARE has no effect.

For a partitioned space, BMC AMI Recover can schedule a BUILD phase for each partition of a partitioning index after the completion of the MERGE phase for the corresponding table space partition. In this case, the BUILD phase for the index partition can overlap the MERGE phase for the next partition. The BUILD phase for the partitions of a partitioned index can also be scheduled after all MERGE phases for the table space partitions have completed.

BMC AMI Recover chooses the most efficient strategy to reduce sort times and the number of bytes that are sorted. The number of BUILD phases and index key sorts that can run concurrently is equal to the value of MAXKSORT.

Sort tasks are shown as shaded boxes in the background in the following figure.

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

GUID-92AEF839-AD8D-4814-9AE9-55050C29F681-low.png


 

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