Recovering a table space

Each table space that is involved is unavailable for most other applications until recovery is complete. If you make image copies by table space, you can recover the entire table space, or you can recover a data set or partition from the table space. If you make image copies separately by partition or data set, you must recover the partitions or data sets by running separate RECOVER operations.

The following RECOVER statement specifies that the utility is to recover table space DSN8S11D in database DSN8D11A:

RECOVER TABLESPACE DSN8D11A.DSN8S11D

To recover multiple table spaces, create a list of table spaces that are to be recovered; repeat the TABLESPACE keyword before each specified table space. The following RECOVER statement specifies that the utility is to recover partition 2 of the partitioned table space DSN8D11A.DSN8S11E, and recover the table space DSN8D11A.DSN8S11D to the quiesce point (RBA X'000007425468').

RECOVER TABLESPACE DSN8D11A.DSN8S11E DSNUM 2
        TABLESPACE DSN8D11A.DSN8S11D
        TORBA X'000007425468'

The following example shows the RECOVER statement for recovering four data sets in database DSN8D11A, table space DSN8S11E:

RECOVER PARALLEL (4)
		  TABLESPACE DSN8D11A.DSN8S11E DSNUM 1
        TABLESPACE DSN8D11A.DSN8S11E DSNUM 2
        TABLESPACE DSN8D11A.DSN8S11E DSNUM 3
        TABLESPACE DSN8D11A.DSN8S11E DSNUM 4

Each of the 4 partitions will be restored in parallel. You can also schedule the recovery of these data sets to run in four separate jobs.

If a table space or data set is in the COPY-pending status, recovering it might not be possible.