The web blog http://www.learnsccd.com strives to be a comprehensive guide to SCCD, TADDM, SERVICE NOW and MAXIMO tools. This is a personal site maintained solely by me. I intend to update it regularly.For live updates please follow us on.

How to DB2 Backup and Restore?

DB2 Backup and Restore

Backup:
======
Step 1: Stop MXServer from was console
Step 2: su - db2inst2
Step 3: db2 force application all
step 4: db2 backup database maxdb75 to /db2_data1/backup111 compress

Restoring backup:
================
Step 1: db2 restore database maxdb75 FROM /db2_data1/backup111 taken at 20140402345863 into maxdb75 replace existing

Step 2: db2 rollforward db sample to end of logs and complete

Step 3: db2 Infocenter

Windows case use below for restore
-----------------------------------
db2 restore database maxdb75 user <username> using <password> from D:\ibm on D:\ibm