PSINDEXBLD control statement
Specifies whether the partitioned secondary indexes (PSINDEXes) for the database are built in the Smart Reorg job step.
This control statement is optional and is used for HALDBs. If the database to reorganize is a non-HALDB, this control statement is ignored. The default is PSINDEXBLD=NO.
- YES
- The Index Builder task is called to build all PSINDEXes for the database.
For more information about how DD names and data set names are processed when PSINDEXBLD=YES is specified, see Considerations for secondary indexes.
- NEW
- PSINDEXes are rebuilt in new data sets.
- CURRENT
- PSINDEXes are rebuilt in existing data sets.
- COND
- The processing mode for building PSINDEX is determined automatically. Update mode is selected if
either of the following conditions is met:
- The PARTITION control statement specifies only some partitions of the HALDB.
- The Conditional Reorganization Support Service (CRSS) identifies that only some partitions of the HALDB require reorganization.
- LOAD
- Builds PSINDEXes in load mode. In load mode, all the PSINDEX records are loaded to the PSINDEX.
- UPDATE
- Builds PSINDEXes in update mode. In update mode, only the PSINDEX records that point to the
reorganized HALDB partitions are updated.
- If you specify PSINDEXBLD=YES,CURRENT,UPDATE, the existing data sets for PSINDEX are updated.
- If you specify PSINDEXBLD=YES,NEW,UPDATE, all the records in the existing data sets are copied to the new data sets by the IDCAMS REPRO command, and then the new data sets are updated.
- NO
- The Index Builder task is not called and no PSINDEXes are built.
Requirement: PSINDEXBLD=YES requires that a supported version of
IMS Index Builder is installed and configured. For
instructions, see Setting up IMS Index Builder.