471,337 Members | 1,083 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

DB2 UDB Recovery after Total Media Failure or Server Loss due to Extreme Disaster

First let me start by saying I am not a DBA nor do I claim to be one, ok with that out of the way I am looking for some help understanding DB2 UDB Recovery after Total Media Failure or Server Loss due to Extreme Disaster.

Currently on my system hot backups are being run on a daily basis with cold backups being executed during a down window on the weekend. The backup data is sent to tape which is then sent off site for safety. Hypothetically, what would I need to do to rebuild the database (BCP Plan) using the backup files on a new server should I need to recover.

Would laying down DB2 UDB on the new box then restoring the cold backup be sufficient to recreate the environment? Example all components from structures to table data thus a mirror image would be created or is there more involved? Is my understanding correct or would I have to employ additional procedures?
Mar 21 '08 #1
0 1169

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Network Administrator | last post: by
18 posts views Thread by Jason Tesser | last post: by
2 posts views Thread by Strahimir Antoljak | last post: by
6 posts views Thread by shorti | last post: by
3 posts views Thread by =?Utf-8?B?U3VzYW4=?= | last post: by
reply views Thread by Winder | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.