UNLOADKEYS and BUILDINDEX strategy

The rebuilding of large nonpartitioned indexes on partitioned table spaces is a major recovery issue.

To recover these objects with a conventional strategy requires a sequential read pass of all partitions of the table space. In some cases, the amount of time that is required to read the partitioned space and rebuild the index with a conventional strategy is prohibitive. To facilitate the recovery of these spaces, BMC AMI Recover provides concurrency in the extraction of keys from multiple partitions.

For example, if you have a large 16-partition table space with a nonpartitioned index that must be recovered (perhaps because of media failure), BMC AMI Recover provides an alternative strategy that uses the RECOVER UNLOADKEYS and RECOVER BUILDINDEX command statements. You can submit up to 16 jobs to extract keys from multiple partitions simultaneously. Sixteen jobs are not required. You can submit up to one job per partition. If you have only eight available initiators, you can submit eight jobs, with each job reading two partitions sequentially. Any combination (10-2-4, 4-4-4-4, and so on) of partitions per job is acceptable.

Related topics

Key-concepts

MAXKSORT

Data sets needed for parallel index sorts and rebuilds

Recovering-a-table-space-and-rebuilding-a-partitioned-index-and-a-nonpartitioned-index

Specify the RECOVER UNLOADKEYS command statement for the nonpartitioned index and specify the PART option to indicate which table space partition is to be used for this key extraction. Include a DD statement in the JCL to specify the work data set to hold the keys. The extracted key files are sorted and are then input to the RECOVER BUILDINDEX job where the keys are merged to build the index.

The improved concurrency can drastically reduce the elapsed time that is required to rebuild a nonpartitioned index. Because RECOVER UNLOADKEYS performs the sorting, particularly for a large, partitioned space, you might see performance improvements because a number of smaller sorts are done.

You can extract the keys for RECOVER UNLOADKEYS indexes during the table space recovery process, further reducing the total elapsed time for combined table space and index recovery. For an example of a combined LOGSORT/MERGE strategy and UNLOADKEYS/BUILDINDEX strategy, see Example-6-Extracting-nonpartitioned-index-keys.

 

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