DB2 Database Requirements

If you are using DB2 for the CMS or auditing database:

Ensure that the CMS database is not partitioned.
Note: The auditing database can be partitioned.
Create the database with these settings:
```
Collating Sequence = “Identity”
Codeset = “UTF-8”
Territory = “XX”
```
If your DB2 database does not have the correct Collating Sequence setting, the user and usergroup objects may not sort properly in the CMC.

Replace XX with the code that is appropriate for your location. See your DB2 documentation for more information.
If you are using DB2 8.1, install and configure a C compiler to build SQL stored procedures. DB2 8.2 through version 9.1 do not have this requirement. BusinessObjects Enterprise uses stored procedures when users are added to groups. See the DB2 documentation for details about how to configure the C compiler for SQL stored procedures.

After the database is created, prepare the database for the BusinessObjects Enterprise installation.

More information: