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.

Read syntax diagramSkip visual syntax diagramPSINDEXBLD=NOYES,NEWCURRENT,CONDLOADUPDATE
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.

The second parameter specifies the data sets in which PSINDEXes are rebuilt:
NEW
PSINDEXes are rebuilt in new data sets.
CURRENT
PSINDEXes are rebuilt in existing data sets.
The third parameter specifies the processing mode for IMS Index Builder:
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.