Backing up and restoring other supported databases

As purchased, IBM® Rational® Quality Manager is configured to run with a Derby database. Changing to a database such as DB2® database, Oracle, or SQL Server can provide better performance, scalability, and reliability in a production environment. This topic provides on overview of the steps involved for backing up and restoring the database. The examples provided are for DB2. For complete instructions, refer to the documentation supplied by your database vendor.

Procedure

To back up a DB2 database or other supported database:

  1. Stop the Jazz™ Server.

    The default Jazz Server is Apache Tomcat. For improved performance, scalability, and reliability, you can use WebSphere® Application Server.

  2. Follow the instructions in your database documentation for backing up the Rational Quality Manager Jazz repository. In the case of a DB2 database, complete these steps:
    1. Locate the Jazz repository in DB2 database.
    2. Right-click the Jazz repository, and select Backup.
    3. For the Media type, select File system, and point to the location for saving the backup.
    4. Click Finish.
    5. Restart the Jazz Server.
  3. To restore an existing DB2 database with the version that you backed up:
    1. Stop the Jazz Server.
    2. Locate the Jazz repository in DB2 database.
    3. Right-click the Jazz repository, and select Restore.
    4. Click Restore to new database.
    5. Type a name for the new repository.
    6. Select the directory that contains the backup.
    7. Click Finish.
    8. Open the RQM_install_dir\RQM\server\conf\jazz\teamserver.properties file.
    9. Replace the name of the Rational Quality Manager Jazz repository with the name that you provided in step e, as shown in the following example. 
      #
# DB2 configuration
#

# Comment out above lines, uncomment the following three lines and customize example location to use DB2
#com.ibm.team.repository.db.vendor = DB2
#com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2admin;password={password};
#com.ibm.team.repository.db.jdbc.password=db2admin
      Note: In the preceding example, the name of the Jazz repository is JAZZ.
    10. Save your changes.
    11. Restart the Jazz Server.
Feedback