Follow these instructions to install DB2® database,
create a DB2 database, and configure DB2 for
use with IBM® Rational® Quality
Manager.
IBM Rational Team Concert provides
additional information on configuring the DB2 database.
This information might be useful as a supplement to this information.
You can find the Rational Team Concert information
at Setting up a DB2 database. Then open topic:
Installing and upgrading > Installing Rational Team Concert >
Installing Rational Team Concert Standard
Edition > Setting up the database.
To install and configure Rational Quality Manager for
use with a DB2 database:Rational Quality Manager:
- If DB2 database has not yet been installed, do so
now. Follow the instructions in the DB2 installation
guide.
- Install fix pack FP4 for DB2 v9.1.
- Install the license for DB2 database.
- Copy the DB2_Enterp_Svr_CPU_Activation.zip file
to a temporary folder on the DB2 Server; for example: C:\temp
dir.
- Extract the compressed file.
- Run the db2cmd command and type this
command: db2licm -a C:\temp\db2\license\db2ese_c.lic. Note that during the DB2 installation,
the installer requests a user name and password to be used for DB2 administration.
Remember these credentials because you will need to use them later
in the teamserver.properties file.
- On the DB2 server, start the DB2 Control
Center.
- Right-click All Databases, select Create
Database, and then select Standard. The Create Database Wizard starts.
- On page 1 of the Create Database Wizard complete these
steps:
- As database name, type: RQM.
- Specify the default path, for example: C:\.
- Select the option Let DB2 manage my storage
(automatic storage).
- Specify 16K as the value for bufferpool and tablespace.
- Click Next.
- On page 2 of the Create Database Wizard, complete these
steps:
- Accept the default values.
- Click Next.
- On page 3 of the Create Database Wizard, make sure the
following options are set as indicated:
- Country/Region is set to: default.
- Territory is set to: US.
- Code Set is set to: UTF-8.
- Collating Sequence is set to: System.
- Click Next.
- click Finish.
Note: The
next series of steps are completed on the Rational Quality Manager server.
- Configure Rational Quality Manager database
properties in the teamserver.properties file. Rational Quality Manager uses
this file to specify various properties including database settings.
By updating the teamserver.properties file, you
can use the DB2 database instead of the Derby database.
- To configure teamserver.properties for
a DB2 database:
- In the teamserver.db2.properties file
change database host name (or IP address), database name, DB2 user
name and password as shown in the following graphic.
- Add the following lines to the teamserver.db2.properties
file. (Change the port numbers to match your WebSphere® Application
Server configuration.)
#websphere port configuration
com.ibm.team.repository.server.repourl.port.http=9080
com.ibm.team.repository.server.repourl.port.https=9443
Note: These
are the default port numbers. If you have not installed WebSphere Application
Server and you use other port numbers, you will need to make these
port numbers match the port numbers assigned in WebSphere Application
Server.
- Rename the existing file named teamserver.properties to teamserver.propertiesBAK.
- Rename teamserver.db2.properties to teamserver.properties.
- Edit provision profiles. Jazz™ uses
provision profiles to specify the plugin path for future fix pack
and release updates. These profiles are also used when database tables
are created. The provision profiles need to have a complete path for
the update directory to function correctly. There are currently three
provision profiles (C:\RQM\server\provision_profiles). Edit each to
include a full path as follows:
- profile.ini: url=file:///C:/RQM/server/update-site
featureid=com.ibm.team.rtc.server.feature
- rqm-license-profile.ini: url=file:///C:/RQM/server/rqm-license-update-site
featureid=com.ibm.rqm.licensing.standard.feature
- rqm-profile.ini: url=file:///D:/RQM/server/rqm-update-site
featureid=com.ibm.rqm.server.feature
- On Linux®, the syntax variation for editing the
provision profiles are as follows, assuming your Rational Quality Manager installation
directory is /opt/IBM/RQM
- For Red Hat Enterprise Linux 5: url=file:/opt/IBM/RQM/server/ OR
url=file:///opt/IBM/RQM/server/
- For SUSE Linux Enterprise Server 10: url=file:/opt/IBM/RQM/server/
- Now that the teamserver.properties and
provision profiles have been changed, you must run a Jazz utility
called repotools to create the database tables. The repotools.bat
utility file is located in [Rational Quality Manager installation
path]\RQM\server\repotools.bat.
- Open a command window.
- Run repotools.bat: repotools
-createTables logFile=/tmp/repotools.log.
- Save a copy of the teamserver.properties and
provision profiles files to use for next time you install a build.
- On the DB2 server, make a backup copy of
the database after initial creation (including users) so that you
can quickly refresh the database for testing purposes. In the DB2 database,
right-click the database and click Backup.
To restore, right-click the database and click Restore.