DATABASE—Recover All Tablespaces in a Database

The DATABASE keyword recovers all tablespaces in a database.
The DATABASE keyword recovers all tablespaces in a database. If any tablespaces are partitioned, you can specify whether to process the partitions individually or as a whole.
RECOVER DATABASE cannot be used to recover Db2 catalogs or the Db2 directory. Use the RECOVER TABLESPACE syntax instead.
To process indexes in the database, specify the REBUILD control statement.
This keyword has the following format:
DATABASE {
dbname
}
  • dbname
    Specifies the database to recover. You must be authorized for that database.