- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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 store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
- How to delete a DB2 table TAB1?
- How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?
- How to find the primary key of a DB2 table TAB1?
- How to add a row compression to a DB2 table TAB1?
- How can you revert all the DB2 table changes done in a COBOL-DB2 program?
- How to update DB2 table with a duplicate primary key?
- How to find all the foreign keys of a DB2 table TAB1?
- How to find out all the indexes for a DB2 table TAB1?
- What are the limitations of using OUTER JOIN on a DB2 table?
- 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?

Advertisements