Difference between revisions of "RecoverDB2"
From Tranzman Documentation
(Created page with "'''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...") |
(No difference)
|
Revision as of 16:18, 29 August 2018
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
Step3
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