Setting up a DB2 database

Set up a supported DB2® or the bundled DB2 Workgroup Server database to work with the Jazz™ Team Server.

Before you begin

Note:

These instructions do not apply to the parts being installed or configured on z/OS®. For more information, see, Installing Rational® Team Concert on z/OS.

This procedure assumes that the following prerequisites have been met. Consult your DB2 documentation or a DB2 database administrator (DBA) for help.

Procedure

  1. Create the database in the DB2 Command Window. The example commands create a new database called JAZZ. These commands run in the DB2 Command Window. The Command Window can be opened from the application Start menu under the DB2 Command Line Tools menu.
    Note: To ensure proper handling of Unicode content, the database character set must be UTF-8 encoding. Because the AUDITABLE_LINKS table does not fit in the default page size of 4 K on Windows, set the page size to at least 8 K for Rational Team Concert and 16 K for Rational Quality Manager.
    • On Windows®:
      db2 create database JAZZ on c: using codeset UTF-8 territory en PAGESIZE 16 K
    • On Linux:
      db2 create database JAZZ using codeset UTF-8 territory en PAGESIZE 16 K
    Tip: If the database is not running, the command db2start starts DB2.
  2. Locate the file teamserver.properties in the directory JazzInstallDir/server/conf/jazz and rename it to teamserver.derby.properties.
  3. Locate the file teamserver.db2.properties in the directory JazzInstallDir/server/conf/jazz and rename it to teamserver.properties.
  4. Specify the database and connection details in the file teamserver.properties.

    The default connection specification connects to a DB2 database that runs on localhost on port 50000. The database is called JAZZ, and both the user name and password are db2admin. If the default values were used when setting up your database, the teamserver.properties file might already be configured correctly. If not, change this information to match your configuration.

    1. Open the file teamserver.properties in a text editor.
    2. Locate the following lines:
      com.ibm.team.repository.db.vendor = DB2
      com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
      com.ibm.team.repository.db.jdbc.password=db2admin
    3. Edit the value of com.ibm.team.repository.db.jdbc.location for your DB2 server and database.
    4. Edit the value of com.ibm.team.repository.db.jdbc.location for your DB2 user name.
      Note: The DB2 user must have permissions to create tables, table spaces, and modify the database configuration. DB2 users are created by the operating system.
    5. Specify the user password in the property com.ibm.team.repository.db.jdbc.password.
      Note: Do not change the password={password} text in the com.ibm.team.repository.db.jdbc.location property.
    6. If necessary, change the property com.ibm.team.repository.db.db2.content.tablespace.location to a path on your Jazz Team Server where the main table space can be created.
      Note: If this value is not changed from the default of content_tablespace, the table space is created under the database storage location. On Windows, if a new path is specified, it must be specified by using double backslashes, for example: com.ibm.team.repository.db.db2.content.tablespace.location=c:\\db2\\jazz\\content_tablespace.

Feedback