Recovery of indexes

When you recover indexes to a prior point of consistency, some rules apply.

In general, the following rules apply:

• If image copies exists for an indexes, use the RECOVER utility.
• If you take system-level backups, use the RECOVER utility.
• If indexes do not have image copies or system-level backups, use REBUILD INDEX to re-create the indexes after the data has been recovered.

More specifically, you must consider how indexes on altered tables and indexes on tables in partitioned table spaces can restrict recovery.

Before attempting recovery, analyze the recovery information.