Setting index rebuild utility options
From the Index Rebuild Utility Options panel you can update the recovery options that are used by the Index Rebuild utility.
Procedure
-
On the System Recovery Options panel, specify Y in
the Execute Index Rebuild
Edit Options field.
Figure 1. Index Rebuild Utility Options panel (BSY$ROIU): Index Rebuild Utility Options BSY$ROIU V2R2 -------- Index Rebuild Utility Options ------- 2021/08/05 03:35:2 Option ===> ------------------------------------------------------------------------------- Creator: CSOSTR Name: ICA2 DBHDO00 SSID: ICA2 Share Option: U (Upd,View,No) Description: ------------------------------------------------------------------------------- Enter the options for the index rebuild utility: More: + FF GENJCL member name ==> BSYIIB Use FF for HALDB ==> Y (Yes/No) HALDB GENJCL member name ==> FP GENJCL member name ==> BSYFPSI Rebuild even if recoverable ==> Y (Yes/No) Rebuild HALDB on recover to current ==> N (Yes/No) Delete/Define PDS DSN ==> SIR.ICA2.DELDEFS Datasets for GENJCL ==> SIR.ICA2.JCLPDS2 ==> RSQA.BSY220.IBMTAPE.SBSYSAMP
-
On the Application Recovery Options panel, specify one or more of the
index rebuild options:
- FF GENJCL member name
- Specify the skeleton member name to be used for the index rebuild utility when rebuilding indexes associated with full function and HALDB indexes. If the Use FF for HALDB option is set to Y, then this member is also used for HALDB ILDS and PINDEX processing.
- Use FF for HALDB
- Specify Y if you want to use the FF GENJCL skeleton member for processing HALDB ILDS and PINDEX; specify N if you do not want to do this.
- HALDB GENJCL member name
- Specify the skeleton member name to be used for processing HALDB ILDS or PINDEX. If the Use FF for HALDB option is set to Y, then you must leave this field blank.
- FP GENJCL member name
- Specify the skeleton member name to be used for processing Fast Path secondary indexes. If you do not want FP secondary indexes processed, leave this field blank.
- Rebuild even if recoverable
- Specify whether you always want indexes rebuilt after the recovery of the target database. Specify Y to always rebuild indexes. Specify N if you want indexes to be rebuilt only if they cannot be recovered.
- Rebuild HALDB on recover to current
- Specify whether you want the HALDB ILDS and PINDEX rebuilt even when the partition is being recovered to current. Usually, the ILDS and PINDEX do not need to be rebuilt in this situation. Specify Y to rebuild the HALDB ILDS and PINDEX on recovery to current. Specify N to rebuild the HALDB ILDS and PINDEX only when indicated.
- Delete/Define PDS DSN
- Specify the name of a PDS data set that contains IDCAMS statements. These statements are used to delete and redefine the data sets being recovered before running the recovery utility.
- Datasets for GENJCL
- Displays the concatenation of data sets for GENJCL member selection.