Difference between revisions of "RecoverDB2"
From Tranzman Documentation
| Line 18: | Line 18: | ||
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 1100px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap; | {| 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 | + | db2 => RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING |
|} | |} | ||
Revision as of 13:40, 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"
|
db2 => RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING |