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?
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?