Difference between revisions of "RecoverDB2"
From Tranzman Documentation
| Line 1: | Line 1: | ||
| − | '''Step 1''' | + | ==='''Step 1'''=== |
Restore the image on the DB2 client as a file. | Restore the image on the DB2 client as a file. | ||
| − | '''Step 2''' | + | ==='''Step 2'''=== |
Rename the file to the same naming convention as DB2 uses while backing up data locally to disk. | Rename the file to the same naming convention as DB2 uses while backing up data locally to disk. | ||
| Line 12: | Line 12: | ||
Instance Name is DB2 | Instance Name is DB2 | ||
| − | ''' | + | ==='''Step 3'''=== |
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" | ||
: '''''RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING''''' | : '''''RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING''''' | ||
Revision as of 11:10, 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