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 DB2Then 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).

Tip: DB2 is a case-sensitive database. If you are using Rational ClearQuest MultiSite or want to migrate to a different vendor database, you must evaluate your database case-sensitivity settings.

Note: For detailed instructions on completing the tasks in the following workflow, consult your DB2 software documentation.

Table 1. DB2 database configuration workflow
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	DB2 version 9.7 Performance parameter settings: `APPL_MEMORY = AUTOMATIC` (default setting) `APPLHEAPSZ = AUTOMATIC` (default setting) `SORTHEAP = 1024` Log parameter settings: `LOGFILSIZ = 2048` `LOGPRIMARY = 15` `LOGSECOND = 10` Optional setting If you use Rational ClearQuest Connector to synchronize the user database with a Jazz™ project area, set `MAXAPPLS = 200` for the user database and schema repository.
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. `binddb2pkg server database DB2_admin password [port]` 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