Difference between revisions of "RecoverDB2"
From Tranzman Documentation
| Line 16: | Line 16: | ||
Restore the database. The example below restores the database SAMPLE from location in "C:\Backup" | Restore the database. The example below restores the database SAMPLE from location in "C:\Backup" | ||
| − | : | + | {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; |
| + | | | ||
| + | RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING | ||
| + | |} | ||
Revision as of 13:36, 30 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
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 |