Setting up a DB2 database

Setting up a DB2® database for Design Management Server involves creating individual databases for each application that runs on the server. Then, you configure the databases and create tables on them; in most cases the setup wizard completes these steps for you.

Before you begin

Note: These instructions do not apply to installing or configuring a database on z/OS®.
Consult the DB2 documentation or your database administrator to ensure that you meet the following prerequisites:

Procedure

  1. Open a DB2 command window by logging in as the DB2 instance owner and typing the command db2 at a command prompt.
  2. Create a total of 4 databases one each for Jazz™ Team Server (JTS), Data Warehouse (DW), Design Management (DM), and Configuration Management (VVC), with 16K pages and the UTF-8 code set by running the following command on a single line, replacing <db_varname> with database names JTS, DW, DM, and VVC:
    create database <db_varname> on <location> using codeset UTF-8 territory en PAGESIZE 16384
    For location, use the location on disk where you want to store the database or remove it to use the default location.
  3. Optional: Create a separate user at the operating-system level to access the data warehouse database and grant that user administrative privileges over the database. The default user name for the data warehouse user is RPTUSER. For example, to grant the user RPTUSER administrative privileges, use the following commands:
    connect to DW
    grant DBADM on database to user RPTUSER
  4. Run the command quit to exit the DB2 command window.

What to do next

If you use the Design Management Server setup wizard to configure the server, no further database customization is necessary. This setup wizard configures the databases and creates the necessary tables.

If you are not running the setup wizard, you can customize the databases manually; for information, see Setting up a DB2 database in the Rational® Team Concert installation documentation.


Feedback