Recovery of indexes on tables in partitioned table spaces

The partitioning of secondary indexes allows you to copy and recover indexes at the entire index level or individual partition level. Certain restrictions apply to using the COPY and RECOVER utilities on the index level and partition level.

If you use the COPY utility at the partition level and then try to the RECOVER utility the index, an error occurs. If the COPY utility is used at the index level, you can use the RECOVER utility at either the index level or the partition level.

You cannot recover an index space to a point in time that is prior to rotating partitions. After you rotate a partition, you cannot recover the contents of that partition to a point in time that is before the rotation.

If you recover to a point in time that is prior to the addition of a partition, Db2 cannot roll back the addition of that partition. In such a recovery, Db2 clears all data from the partition, and it remains part of the database.