Out of the box, IBM® Rational® Quality Manager is
configured to run with a Derby database. Changing to a database such as DB2®,
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.
To back up a DB2 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 (WAS).
- Follow the instructions in your database documentation for backing
up the Rational Quality Manager Jazz repository.
In the case of a DB2, database:
- Locate the Jazz repository in DB2.
- Right-click the Jazz repository and click Backup.
- For the Media type, select File
system and point to the location where you want the backup to
be saved.
- 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.
- Right-click the Jazz repository and click Restore.
- Click Restore to new database.
- Type a name for the new repository.
- Select the directory that contains the backup.
- Click Finish.
- Open the <Rational Quality Manager _install_path>\server\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 example above, the name of the Jazz repository is JAZZ.
- Save your changes.
- Restart the Jazz Server.