Running RECOVER TABLESPACE and REBUILD INDEX

RECOVER can be used to recover an entire file page set, a single data page in a page set, or pages in error range. RECOVER can be used for table spaces and index spaces. REBUILD INDEX can be used to recover a single index or multiple indexes that are associated with a table space.

Procedure

To run RECOVER TABLESPACE and REBUILD INDEX:

  1. Run RECOVER TABLESPACE for inconsistencies in a table space, supplying the page set name and page number. Run REBUILD INDEX for an inconsistent index, supplying the name of the index. All indexes in a table space can be rebuilt, that is, every index on every table in the table space. Or specify a number of individual indexes (index spaces) to recover.
  2. Verify that the recovery was successful. Message DSNU500I indicates successful data recovery and message DSNU259I indicates a successful index rebuild.
  3. If the inconsistency cannot be resolved with RECOVER TABLESPACE or REBUILD INDEX, use the SVC dump that is issued for the abend. Continue with Resolving inconsistencies manually.

    If an SVC dump is not available, but you know the page number that is involved, obtain a REPAIR, DSN1COPY or DSN1PRNT dump of the inconsistent page. The REPAIR utility can be used with the DUMP option to obtain a dump, or, for 00C90102 abends, DSN1COPY can be used with the CHECK option to obtain a dump. After a dump of the page that is involved in the inconsistency is obtained, continue with Resolving inconsistencies manually.

  4. When in doubt about what page to recover and a dump is not available, contact the IBM® Support Center or IBM Service.