Configuring DB2 V9.1 for use with Rational Quality Manager

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:

  1. If DB2 database has not yet been installed, do so now. Follow the instructions in the DB2 installation guide.
  2. Install fix pack FP4 for DB2 v9.1.
  3. Install the license for DB2 database.
  4. Copy the DB2_Enterp_Svr_CPU_Activation.zip file to a temporary folder on the DB2 Server; for example: C:\temp dir.
  5. Extract the compressed file.
  6. 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.
  7. On the DB2 server, start the DB2 Control Center.
  8. Right-click All Databases, select Create Database, and then select Standard. The Create Database Wizard starts.
  9. On page 1 of the Create Database Wizard complete these steps:
    1. As database name, type: RQM.
    2. Specify the default path, for example: C:\.
    3. Select the option Let DB2 manage my storage (automatic storage).
    4. Specify 16K as the value for bufferpool and tablespace.
    5. Click Next.
  10. On page 2 of the Create Database Wizard, complete these steps:
    1. Accept the default values.
    2. Click Next.
  11. On page 3 of the Create Database Wizard, make sure the following options are set as indicated:
    1. Country/Region is set to: default.
    2. Territory is set to: US.
    3. Code Set is set to: UTF-8.
    4. Collating Sequence is set to: System.
  12. Click Next.
  13. click Finish.
    Note: The next series of steps are completed on the Rational Quality Manager server.
  14. 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.
  15. To configure teamserver.properties for a DB2 database:
    1. 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.
      Example of teamserver.db2.properties file highlighting the location of the hostname, database name, admin user ID and password, and db2 table space size within the file.
    2. 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.
    3. Rename the existing file named teamserver.properties to teamserver.propertiesBAK.
    4. Rename teamserver.db2.properties to teamserver.properties.
  16. 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:
    • On Windows®
    1. profile.ini: url=file:///C:/RQM/server/update-site featureid=com.ibm.team.rtc.server.feature
    2. rqm-license-profile.ini: url=file:///C:/RQM/server/rqm-license-update-site featureid=com.ibm.rqm.licensing.standard.feature
    3. 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
    1. For Red Hat Enterprise Linux 5: url=file:/opt/IBM/RQM/server/ OR url=file:///opt/IBM/RQM/server/
    2. For SUSE Linux Enterprise Server 10: url=file:/opt/IBM/RQM/server/
  17. 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.
    1. Open a command window.
    2. Run repotools.bat: repotools -createTables logFile=/tmp/repotools.log.
  18. Save a copy of the teamserver.properties and provision profiles files to use for next time you install a build.
  19. 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.

Feedback