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.

Start of change

If you changed the partitioning scheme of a table with one of the following conversions, you can recover the table space to the current state or to a point in time after the materializing REORG operation:

  • FL 500 Conversion from partition-by-growth (PBG) to partition-by-range (PBR).

For more details on these restrictions, see Point-in-time recovery.

End of change