Configuring DB2®
To use Rational® ClearQuest® with DB2 databases, you must install a supported release of DB2 on your database server and create and customize the database container.
There are two methods for configuring the DB2 database software. The first method is to create a single DB2 database in one DB2 database server. Then create the Rational® ClearQuest® schema repository and one or more user databases in the single DB2® database. The second method requires that you create multiple DB2® databases for the Rational® ClearQuest® databases on the DB2® database server.
- If you choose the single database method, create one empty DB2® database. For details about how to create an empty Rational® ClearQuest® database with DB2®, see Module: Creating empty Rational® ClearQuest® databases with DB2®Then create a user account for each Rational® ClearQuest® database at the operating system level. When you create the Rational® ClearQuest® schema repository and user databases, use the same database name, but different user accounts created at the system level to own the Rational® ClearQuest® databases. For example, if you create cqrepo and cqdata user IDs at the operating system level, cqrepo can own the schema repository database and cqdata can own the user database under the single database cqdb.
- If you use the multiple database method, create an empty DB2® database for each Rational® ClearQuest® database (schema repository and one more user databases).
| Task | Comments |
|---|---|
| Install a supported version of DB2® | When installing a DB2® database on a supported AIX® platform, make sure the file system on which the database resides allows files to grow larger than 2 GB. |
| Create your DB2® database or databases depending on which method you choose | If you are using the single database method, create user IDs for the Rational® ClearQuest® databases. The DB2® documentation procedure assumes that the public group is assigned permissions by default. When you assign permissions to the DB2® user names that will access the database, the permissions must match those of the public group. If you are using the multiple database method, repeat the database creation procedure for each database. Note: The
default code page for your locale may not be compatible with your Rational®
ClearQuest® environment.
For more information, see Code pages and national language support |
| Add a buffer pool and table space to each of the databases you have created | When you create the buffer pool, set the page size to 32. Set the size of the 32 KB pages to 1024. Create two table spaces for the buffer pool; one regular, and one temporary. |
| Add a public group to each table space you created and assign Use area privileges | Before performing this task, you must create two user accounts on the server to use DB2® with Rational® ClearQuest®. One account is for the schema repository; the other is for the user database. |
| Set parameters for each database you have created |
|
| Bind DB2® packages to the databases you have created |
You must run the following command to bind the packages to the databases before connecting to them from Rational® ClearQuest®. Note: If the database is in a DB2® instance that is not using
port value 50000, the port value must be specified.
Tip: Run the
binddb2pkg command if you are upgrading an existing user
database to a version of Rational®
ClearQuest® that includes an updated version of the
DataDirect driver. For more information about binddb2pkg, see binddb2pkg |