RecoverDB2

From Tranzman Documentation
Revision as of 13:36, 30 August 2018 by Admin (talk | contribs)
Jump to: navigation, search

Step 1

Restore the image on the DB2 client as a file.

Step 2

Rename the file to the same naming convention as DB2 uses while backing up data locally to disk.

i.e. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001

Database Name is Sample Instance Name is DB2

Step 3

Restore the database. The example below restores the database SAMPLE from location in "C:\Backup"

RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING