RecoverDB2

From Tranzman Documentation
Revision as of 16:18, 29 August 2018 by Admin (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

Retrieved from "https://docs.stoneram.com/index.php?title=RecoverDB2&oldid=82"