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...") |
|||
| Line 7: | Line 7: | ||
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. | ||
| − | i.e. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001 | + | : '''''i.e. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001''''' |
Database Name is Sample | Database Name is Sample | ||
| Line 14: | Line 14: | ||
'''Step3''' | '''Step3''' | ||
| − | 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 10:28, 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
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