RecoverDB2

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