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, you require a C compiler that is installed and configured to build SQL stored procedures. DB2 8.2 through version 9.1 do not have this requirement. Stored procedures are used by BusinessObjects Enterprise when users are added to groups. See the DB2 documentation for details about how to configure the C compiler for SQL stored procedures.

Once the database is created, you must prepare it for the BusinessObjects Enterprise installation.

More information: