Reorganizing and recovering secondary indexes

If you are planning to use IMS™ Index Builder for standard recovery of secondary indexes, consider changing the skeletal JCL used by DBRC for recovery. Skeletal JCL execution members are stored in IMS PROCLIB, and they are generated as part of IMS generation.

Procedure

To create JCL to recover indexes, issue the DBRC GENJCL.RECOV command.

DBRC generates the JCL based on the skeletal JCL that is stored in IMS PROCLIB and the current data in the RECON data sets.

You can also use the following IMS database tools for recovering and rebuilding indexes:
  • IMS Database Control Suite creates skeletal JCL for rebuilding indexes for recovery
  • IMS Parallel Reorganization and IMS Database Reorganization Expert integrate with IMS Index Builder to rebuild non-HALDB secondary indexes
  • IMS Database Recovery Facility integrates with IMS Index Builder to rebuild indexes during recovery
Parent topic: Creating secondary indexes