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:
- Ensure that you installed one of the following supported versions
of DB2 on the database server:
- DB2 9.7 Enterprise Server
Edition
- DB2 9.7 Workgroup Server
Edition
- DB2 9.7 Express-C
You can install the database on the model server or on a separate
database server.
- Ensure that you have the user name and password for the DB2 instance user; the default user
name is db2inst1.
- Review the DB2 documentation
to verify that your system meets the requirements and is configured
correctly.
- Ensure that DB2 is running.
As the DB2 instance user, run
the db2start command, or start the database server
from the DB2 control center.
Procedure
- Open a DB2 command
window by logging in as the DB2 instance
owner and typing the command db2 at a command prompt.
- 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.
- 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
- 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.