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:
- Stop the Jazz™ Server.
The default Jazz Server
is Apache Tomcat. For improved performance, scalability, and reliability,
you can use WebSphere® Application
Server.
- 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:
- Locate the Jazz repository
in DB2 database.
- Right-click the Jazz repository,
and select Backup.
- For the Media type, select File
system, and point to the location for saving the backup.
- Click Finish.
- Restart the Jazz Server.
- To restore an existing DB2 database
with the version that you backed up:
- Stop the Jazz Server.
- Locate the Jazz repository
in DB2 database.
- Right-click the Jazz repository,
and select Restore.
- Click Restore to new database.
- Type a name for the new repository.
- Select the directory that contains the backup.
- Click Finish.
- Open the RQM_install_dir\RQM\server\conf\jazz\teamserver.properties file.
- 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.
- Save your changes.
- Restart the Jazz Server.