Configuring DB2

To use HCL Compass 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 HCL Compass 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 HCL Compass 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 HCL Compass database with DB2, see Module: Creating empty HCL Compass databases with DB2Then create a user account for each HCL Compass database at the operating system level. When you create the HCL Compass schema repository and user databases, use the same database name, but different user accounts created at the system level to own the HCL Compass 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 HCL Compass database (schema repository and one more user databases).

Tip: DB2 is a case-sensitive database. If you are using HCL Compass 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 HCL Compass 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 HCL Compass 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 HCL Compass. 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 HCL Compass Connector to synchronize the user database with a Jazz™ project area, set `MAXAPPLS = 200` for the user database and schema repository.