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