Recovering a data set or partition
You can use the RECOVER utility to recover individual partitions and data sets. The phases for data set recovery are the same as for table space recovery.
About this task
If image copies are taken at the data set level, RECOVER must be run at the data set level.
If you took FlashCopy® image copies at the table space level (by specifying the DSNUM ALL option in the COPY statement), you do not have to recover all of the data sets individually. Even though SYSIBM.SYSCOPY contains records for each partition or piece of the FlashCopy image copy data set, you can recover the entire table space as one object in the RECOVER statement. This recovery is possible, because SYSIBM.SYSCOPY also contains a record to indicate that the FlashCopy image copy was taken at the table space level. Alternatively, you can recover each of the data sets individually.
- A single data set for nonpartitioned secondary indexes
- A logical partition of a nonpartitioned secondary index
Procedure
To recover a data set or partition, take one of the following actions:
- If image copies are taken at the data set level and you want to recover the whole table space, recover all of the data sets individually in one or more RECOVER steps. If recovery is attempted at the table space level, Db2® returns an error message.
- If image copies are taken at the table space, index, or index space level, recover individual data sets by using the DSNUM parameter in the RECOVER statement.