Difference between revisions of "RecoverDB2"

From Tranzman Documentation
Jump to: navigation, search
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
  
'''Step3'''
+
==='''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