Recovery of partitioned table spaces

Recovering partitioned table spaces to a point in time has several limitations.

You cannot recover a table 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.

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

If you recover a table space partition to a point in time that is before the data was redistributed across table space partitions, you must include all partitions that are affected by that redistribution in your recovery list.

See the information about point-in-time recovery for more details on these restrictions.