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.

PART

The PART option specifies the partitions of an index on a partitioned table space to rebuild. You can specify the index partition individually in the main body of the REBUILD INDEX command or in a list by using the INDEX (indexName1, indexName2...) option, but you cannot specify the partition in both places. If you specify the partition by using the REBUILD INDEX command statement, you can place the partition specification before or after the TABLESPACE option.

Option

Description

PART ALL

PART ALL is the default and tells BMC AMI Recover to rebuild all partitions of the index space.

PART integer

PART integer tells BMC AMI Recover to rebuild the index space for the specified partition. If you specify a nonpartitioned index, the index entries are replaced for the named partition.

integer must be in the range 1 through 4096.

PART begin : end

Use this option to recover a range of partitions for the index space. For partitioned index spaces, begin specifies the number (from 1 through 4095) of the first partition in the range and end specifies the number (from 2 through 4096) of the last partition in the range. The two numbers are separated by a colon (:) with or without spaces. Wrapping partition numbers (for example, DSNUM 4050 : 300) is not supported.

Related topics

REBUILD-INDEX-option-descriptions

Example-6-Extracting-nonpartitioned-index-keys


 

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