DB2 – Restore database from a ONLINE backup

07 January,2012 by Tom Collins

I completed a DB2 backup on server1 with the command:

db2 backup db sample online include logs
Backup successful. The timestamp for this backup image is : 20120106215500

  There was a requirement to RESTORE this database from TSM onto Server2.
I logged on to Server2  and checked I could view the backup copy with:

db2adutl verify full taken at <20120106215500> db mydb
Image Verification Complete - successful.

This was successful . To restore the backup image – the command is:

db2 RESTORE db sample use tsm taken at 20120106215500
db2 rollforward db sample to end of logs
db2 rollforward db sample complete

 Related Posts

DB2 SQL2033N and TSM reason code 106

Author: Rambler(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DB2 – Restore database from a ONLINE backup

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright