Full System Recovery of DB2 Database: Rebuilding the Operating System

In the case of disaster recovery, where a full system restore is required, you must first rebuild the system to exactly the state as it existed before the problem

Procedure

  1. Rebuild the hardware if needed.
  2. Install the same version of the operating system with the same patches that were previously installed.
  3. Install the File System Agent on the client.
  4. Perform a full system restore of the File System Agent.
  5. This will restore the DB2 application files and all of the Agent software. If there are any problems with the DB2 Agent, we recommend that you un-install and re-install the software in the same drive as it was previously installed. Use the same installation parameters, passwords, and backup type settings as were previously used. In addition to restoring your operating system, this operation will restore the DB2 application files and the DB2 Agent.
  6. Reboot the computer.
  7. Install the DB2 Agent (again) without deleting the DB2 Agent icon from the CommCell Console. If you do delete this icon before installing the Agent, you will lose all the DB2 backups. On Windows, you are prompted to provide directory paths several items. The system will not accept the directory paths that you entered for the original install during a reinstall. Therefore, be sure to enter "new" directory paths during a reinstall.
  8. Enter the following command at the client computer for each database to be restored to determine whether any DB2 database applications were running during the previous full system backup:

    db2 connect to <database name>

    where database name is the name of the database.

    If a connection is made to each database, the restore procedure is completed. 

    However, if a connection to any database is unsuccessful, a message for each unsuccessful attempt similar to the following appears:

    SQL 1036C  An I/O error occurred while accessing the database.  SQLSTATE=58030"

    In such a case, go to the next step.

  9. Drop each database to which no connection was made in the previous step. To this purpose, enter the following command for each such database:

    db2 drop database <database name>

    where database name is the name of the database.

What To Do Next

Restore using browse and bring up each dropped database from its database backup image.