Creating the project results database by using IBM DB2

You can create project results databases that are based on IBM® DB2®.

Before you begin

For information about the supported versions of the database, see the Supported Software > Database section in the System Requirements page.

Procedure

Install and configure DB2.

Run the create database command to create a new database. For example, create a database that is named ritres by using the UTF-8 code set:

C:\Users\Administrator>db2 create database ritres using codeset UTF-8 territory en
DB20000I  
The CREATE DATABASE command completed successfully.

Connect to DB2. For example:

C:\Users\Administrator>db2 connect to ritres user db2admin using xxxxx
Database Connection Information
Database server        = DB2/NT64 9.7.6
SQL authorization ID   = DB2ADMIN
Local database alias   = RITRES

Using a command of the following format, run the ghtester_db2.sql script against the new database:
```
<Rational Integration Tester installation directory>\scripts>db2 -vtf ghtester_db2.sql > rit\output.log
```
For example:
```
C:\Program Files\IBM\RationalIntegrationTester\scripts>db2 -vtf ghtester_db2.sql > rit\output.log
```
Important: This script works only with DB2 versions later than 9.5. For versions 9.5 and earlier, run ghtester_db2_9.5.sql.
Open the output.log file in a text editor and verify that there are no errors.

Feedback