Skip to Content

Using the traditional method to recover indexes

The traditional method for recovering an index is to use the same procedures that you would use when recovering any non-index database.

You would restore the index using a previous image copy and then apply the appropriate change records. The IBM Database Recovery utility uses this procedure during its recovery process.

Related topics

Methods-for-rebuilding-indexes

Considerations

  • The index must be empty. Use the IDCAMS keyword to delete and define the VSAM data sets.
  • Indexes that are explicitly specified in a REC or AREC control statement are recovered using the traditional method unless they are defined as non-recoverable.

Example control statements

The following control statement examples use the example database described in Example-database-information-for-rebuilding-indexes.

  • Use the following REC statements to recover the following related databases:

    GLBL DBRC(Y) DBALLOC(Y) DSALLOC(Y)
    GROUP DUMP(*) ACCUM(*) LOG(*) IDCAMS(*)
    REC DBD(DBPBB)  DDN(DDPBB1)
    REC DBD(DBPBB)  DDN(DDPBB2)
    REC DBD(DBSBB1) DDN(DDSBB1)
    REC DBD(DBSBB2) DDN(DDSBB2)
    REC DBD(DBSBB2) DDN(DDSBB3)

  • Use the following statements to achieve the same results by recovering database data set group APPLGRP, instead of specifying REC statements:

    GLBL DBRC(Y) DBALLOC(Y) DSALLOC(Y)
    GROUP DBDSGRP(APPLGRP) FUNC(REC) -
          DUMP(*) ACCUM(*) LOG(*) IDCAMS(*)

 

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

BMC AMI Backup and Recovery for IMS 5.2