Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting
a “bad page”. DB2DART is performed for the entire database and it appears that several bad pages were
detected in table space TBSP_1. What command should be used to recover the database and repair the
corruption in table space TBSP_1?
A.
RESTART DATABASE
B.
RESTORE DATABASE
C.
RESTORE TABLESPACE
D.
ROLLFORWARD DATABASE
Example:
To restore tablespace USERSPACE1 from a backup image (database level or tablespace level):
$ db2 “restore db sample tablespace (USERSPACE1) taken at 20141013180552”
DB20000I The RESTORE DATABASE command completed successfully.
0
0