Recovery of partition-by-growth table spaces

The RECOVER utility supports both table space-level and partition-level recovery on a partition-by-growth (PBG) table space.

Because the number of partitions is defined on demand, the total number of partitions in an image copy may not be consistent with the number of partitions that reside in the current table space. In such a case, when recovering the table space back to a point in time with an image copy that has less partitions, the excess partitions in the table space will be empty because the recover process has reset the partitions.

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