RecoverDB2

Steps to be followed after importing the images to NBU

In the following example, there is a database called SAMPLE ; the recovery logs are included in the backup image; the database is restored; and the database is rolled forward to the end of backup timestamp.

Step 1

Restore the image on the DB2 client as a file.

Step 2

Filename will have a naming convention as shown below.

e.g. SAMPLE.0.DB2.NODE0000.CATN000.20180523164142.001

Database Name is Sample Instance Name is DB2 Timestamp is 20180523164142 Catalog Name is CATN000

Step 3

Restore the database. The example below restores the database SAMPLE from location in "C:\Backup"

> db2 => RESTORE DATABASE SAMPLE FROM "C:\Backup" TAKEN AT 20180627095334 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING

Step 4

Roll the logs forward to the end of the backup to make sure the database is in a consistent state.

db2 => restore database sample from "C:\backup" taken at 20180919172832 with 2 b uffers buffer 1024 parallelism 1 without prompting SQL2540W Restore is successful, however a warning "2539" was encountered during Database Restore while processing in No Interrupt mode. db2 => rollforward db sample to end of backup Rollforward Status Input database alias = sample Number of nodes have returned status = 1 Node number = 0 Rollforward status = DB working Next log file to be read = S0000000.LOG Log files processed = - Last committed transaction = 2018-09-19-16.28.42.000000 UTC DB20000I The ROLLFORWARD command completed successfully.

Note : If log files are not included in backup images, the rollforward recovery needs to be done as per the method used for backing up logs.

---

Use this link to go back to the main recoverydocs Page.