Difference between revisions of "RecoverDB2"
From Tranzman Documentation
| Line 20: | Line 20: | ||
db2 => 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 | ||
|} | |} | ||
| + | |||
| + | ---- | ||
| + | Use this link to go back to the main [[recoverydocs]] Page. | ||
Revision as of 11:14, 18 September 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 |
Use this link to go back to the main recoverydocs Page.