Restoring the database using IBM Data Studio client

To restore the IBM Spectrum® Control database (TPCDB), use the IBM® Data Studio client.

Download and install the IBM Data Studio client. For more information about how to download and install the IBM Data Studio client, see External link iconhttp://www.ibm.com/developerworks/downloads/im/data/.

Before you can use the IBM Data Studio client to restore the IBM Spectrum Control database, you must add a connection to the database in the IBM Data Studio client.

Restriction:

Do not restore the IBM Spectrum Control database backup from one version of IBM Spectrum Control into another version. For example, do not restore a backup from IBM Spectrum Control Version 5.3.4 into Version 5.3.7, or any other version.

  1. Stop the IBM Spectrum Control services.
  2. Start the IBM Data Studio client.
  3. Click the Administer tab in the Data Studio client Task Launcher, then click Connect and browse a database.
  4. On the Connection Parameters page, click DB2 for Linux, UNIX, and Windows and configure your IBM Spectrum Control database connection parameters.
  5. Click Next.
  6. On the Database Administration - IBM Data Studio page, expand DB2.
  7. Right-click TPCDB, then click Back Up and Restore > Restore.
  8. On the Restore Database TPCDB page, click Restore backup to the current database to set the restore type.
  9. Click Restore Objects, and then click Restore the entire database.
  10. Select the backup image that you want to restore.
  11. On the Restore Database TPCDB page, click Run.
  12. Restart the IBM Spectrum Control services.