Search dba-db2.com
*Use the Comments section for questions
Daily & Exclusive Content
Recent Posts
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
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
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.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |