How to recover a DB2 table space TABSPC1 using the image copy TOLASTCOPY?

The DB2 provides an utility RECOVER which is used to restore the tablespace. This utility uses image copy and DB2 logs to restore the changes. The following command can be used to recover the tablespace to the last image copy that was taken.

RECOVER TABLESPACE DBSET1.TABSPAC1 TOLASTCOPY

The RECOVER TABLESPACE is followed by the name of tablespace qualified by the database in which it resides. The TOLASTCOPY parameter will restore the image copy in the following way. If the most recent image copy is full image copy, then the full image copy is restored in the tablespace. If the most recent image copy is the incremental image copy then the latest full image copy will be restored along with the recent incremental image copy.

Mandalika

Published on 12-Sep-2020 14:57:02

• Related Questions & Answers
• How to image copy the entire DB2 table TAB1 into a dataset?
• How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
• How to copy a table in MySQL using Python?
• How to delete a DB2 table TAB1?
• How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
• How to store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
• How to find the primary key of a DB2 table TAB1?
• How can you revert all the DB2 table changes done in a COBOL-DB2 program?
• What are the limitations of using OUTER JOIN on a DB2 table?
• Write the DB2 SQL query to find the third highest ORDER_TOTAL in a ORDERS DB2 table
• How to add a row compression to a DB2 table TAB1?
• How to find all the foreign keys of a DB2 table TAB1?
• How to find out all the indexes for a DB2 table TAB1?
• How to copy the palette from one image to another using imagepalettecopy() function in PHP?
• Write a DB2 query to find out all the duplicate INVOICE_ID in ORDERS DB2 table?