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.

Sort performance


Performance of an 

BMC AMI Recover

 recovery is routinely measured by the elapsed time of the total job.

One of the biggest factors that influences elapsed time is sorting log data, index keys, or both. BMC AMI Recover offers many options that enable you to control the efficiency of the sort and customize the sort based on your environment.

Multiple concurrent key sorts provide the greatest performance gain for the product. For each table space, BMC AMI Recover distributes the index keys for all indexes being rebuilt over a user-defined number of sorts and runs these sorts in parallel. For a partitioned table space, if the partitioning index is being rebuilt, BMC AMI Recover does the rebuild of each partition at the completion of the MERGE or UNLOAD for each partition of the table space and this may happen concurrently with the MERGE or UNLOAD for the next partition (if the user-specified number of sorts is not exceeded).

When BMC AMI Recover has input all of the keys to the sort for a group of indexes, BMC AMI Recover then performs the REBUILD operation for each index in a subtask. There could be one subtask for each group of indexes that were sorted in the previous MERGE or UNLOAD phases. So, index REBUILDs can run concurrently.

BMC AMI Recover determines the number of concurrent REBUILDs for each table space during analysis but never exceeds the user-specified number of sorts. Once BMC AMI Recover schedules all of the REBUILDs for a table space in multiple subtasks, it begins the next MERGE or UNLOAD for a different table space if the user-specified number of sorts will not be exceeded.

BMC AMI Recover uses BMC BMCSORT technology for sorts. This technology provides BMC AMI Recover with more control of the sort process than external sort routines provide. This added control helps prevent memory-related problems during the sort process.

BMC AMI Recover allocates the amount of resources to each sort process based on the amount of work that BMC AMI Recover determines that the sort process will perform. BMC AMI Recover also dynamically detects excess available memory and allocates a percentage of them to the sort processes.

The following areas are of major importance to sort performance and can be customized:

  • Number of parallel sorts allowed
  • Central and expanded storage
  • DASD work space

In general, the more central and expanded storage available to the sort, the better the sort performs. In most cases, the BMC AMI Recover and sort installation default values are sufficient, but if the defaults are not appropriate for your needs, you can use BMC AMI Recover options to override them.

This section contains the following topics:


 

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