TABLESPACE—Recover a Tablespace

The TABLESPACE keyword specifies the tablespace to recover.
cafrdb2
The TABLESPACE keyword specifies the tablespace to recover. You can list multiple tablespaces within the same RECOVER statement. If you also specify MAXTASKS, the tablespaces are recovered concurrently where possible. The RBA, log point, and global options that you specify are applied to all objects in the list. The OBID translation and recover DSN options apply only to the tablespace for which they are specified.
Review the following considerations:
  • The TABLESPACE keyword must precede each tablespace name that you specify. See the following example:
    RECOVER TABLESPACE
    tsname1
    TABLESPACE
    tsname2
    TABLESPACE
    tsname3
  • To take an image copy of each tablespace in the list, specify QUICKCOPY after each tablespace specification.
  • You can use RECOVER TABLESPACE to process the Db2 catalog and Db2 directory.
This keyword has the following format:
TABLESPACE {[
dbname
.]
tsname
}
  • dbname
    Specifies the database name. You must have authorization for the
    dbname
    you define. If you do not specify dbname, the default database DSNDB04 is used.
    Default:
    DSNDB04
  • tsname
    Specifies the tablespace name.