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.

OBJECTSET specification for REBUILD INDEX

Use OBJECTSET (REBUILD INDEX OBJECTSET creator.name) to specify that you want to rebuild all of the indexes in a group that was defined using 

BMC AMI Recovery Manager

.

Important

SIMRBLD is also valid in place of REBUILD.

The OBJECTSET specification is shown in REBUILD-INDEX-syntax. 

OBJECTSET creator.name

The following rules apply to creator.name:

  • creator specifies the name of the creator of the group and can have up to 128 characters in length.
  • name species the group name and can have up to 128 characters in length.
  • You can delimit both creator and name with single or double quotation marks.
  • Both creator and name can contain the special characters $, #, and @ in any position.

BMC AMI Recover uses dynamic grouping to determine the group contents at the time that you run the BMC AMI Recover job containing the OBJECTSET option. Because BMC AMI Recover reads the objects in the group each time the job is executed, objects may be added or removed from the group.

Important

BMC AMI Recover does not read BMC AMI Recovery Manager recovery options for the group. If BMC AMI Recovery Manager recovery options change, you must run BMC AMI Recovery Manager to pick up the new options and generate the control cards.

Following are restrictions that apply when you use OBJECTSET with REBUILD INDEX:

  • AUX is ignored with any specification of OBJECTSET.
  • You cannot specify PART with OBJECTSET. BMC AMI Recover uses the group definition for the object.
  • You cannot use INDEP INTABLESPACE with OBJECTSET.
  • You cannot use TABLESPACE with OBJECTSET.

EXCLUDE (dbname.ts or qualifier.ix)

Use the EXCLUDE option after an OBJECTSET specification to exclude one or more objects from the rebuild. You can use wildcards or specific names to specify the exclusions. The following wildcards are valid:

  • % and * match any number of characters in the object name.
  • _ and ? match a single character in the object name.

List the excluded objects following the EXCLUDE keyword. Each item in the list must be in the form dbname.ts or qualifier.ix and you must separate the individual items with commas. Enclose the list in parentheses.

DSNUM

DSNUM specifies a single data set in the specified space or the entire space for rebuild.

DSNUM ALL

DSNUM ALL is the default and specifies that all of the data sets in the space are to be rebuilt. If the space is nonpartitioned and DSNUM ALL is specified or implied, image copies made for specific data sets will only be considered for rebuild if they are registered at the same log point.

DSNUM integer

Use this option to rebuild only one partition or data set in the space. For partitioned spaces, DSNUM integer specifies the number (from 1 through 4096) of a single partition in the specified space. For nonpartitioned spaces, DSNUM integer specifies the number (from 1 to 32) of a single data set of the specified space.

DSNUM begin : end

Use this option to rebuild a range of partitions in the space. For partitioned 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 topic

REBUILD-INDEX-option-descriptions



 

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