Recovery of indexes on altered tables

Using some ALTER statements interferes with the use of the RECOVER utility to restore the index to a point in time before the ALTER statement was used.

Begin general-use programming interface information.You cannot use the RECOVER utility to recover an index to a point in time that existed before you issued any of the following ALTER statements on that index. These statements place the index in REBUILD-pending (RBDP) status:

  • ALTER INDEX PADDED
  • ALTER INDEX NOT PADDED
  • ALTER TABLE SET DATA TYPE on an indexed column for numeric data type changes
  • ALTER TABLE ADD COLUMN and ALTER INDEX ADD COLUMN that are not issued in the same commit scope
  • ALTER INDEX REGENERATE End general-use programming interface information.

When you recover a table space to prior point in time and the table space uses indexes that were set to RBDP at any time after the point of recovery, you must use the REBUILD INDEX utility to rebuild these indexes.