Suggested settings for creating the content store in IBM Db2 on Linux, Windows, and UNIX operating systems
To ensure a successful installation, use the following guidelines when creating the content store. Use the same guidelines to create a database for log messages.
Guidelines for creating the content store
Use the following checklist to help you set up the content store on Db2®.
- Set the appropriate environment variables for Db2, which
are as shown in the following table.
Table 1. Environment variables for Db2
The top-level directory that contains the database client software or the entire database installation.
The load library path.
Add the driver location to the path, and replace the double hash symbol with
LD_LIBRARY_PATH= $DB2_location/sqllib/lib##: $LD_LIBRARY_PATH
LD_LIBRARY_PATH= $DB2DIR/lib##: $LD_LIBRARY_PATH
The default database server connection.
Setting this optional environment variable to a value of 1208 provides support for multilingual databases.
For information about whether to use this environment variable, see the Db2 documentation.
- Use UTF-8 as the
code set value when you create the database.
To check that your database has the correct code set, using the command-line interface, and type the following at the command prompt:
db2 get database configuration for database_name
The code set value is UTF-8 and the code page value is 1208.
- Ensure that you set the configuration parameters as shown in the
Table 2. Configuration parameters for Db2
Application heap size
AUTOMATIC or at least 1024 KB
If the application heap size value is too small, out of memory errors may occur when there are many users.
Lock timeout (locktimeout)
Do not set this to an infinite timeout value.
Db2 registry variable (DB2_INLIST_TO_NLJN)
Setting this variable to YES improves performance.
- Create a buffer pool with a page size of 32 KB, and a second one with a page size of 8 KB.
- Create a system temporary tablespace using the 32 KB buffer pool you created in the previous step.
- Create a user temporary tablespace using the 8 KB buffer pool
Global temporary tables will be created in the user temporary tablespace.
- Grant the following database privileges for the user account IBM®
Cognos® Analytics will
use to access the database:
Tip: If you want to host more than one content store on your Db2 instance and you use both at the same time, use a different user account for each content store to ensure that each IBM Cognos Analytics instance is fully isolated from the other.
- Connect to database
- Create tables
- Create schemas implicitly
- Ensure that the user account has use privileges for the user temporary tablespace and other appropriate tablespaces associated with the database.
- Create a schema for the user account IBM Cognos Analytics that you will use to access the database, and ensure the user has create, drop, and alter permissions for the schema.
- Create a profile that sources the sqllib/db2profile from the Db2 user's
home directory. For example, the content of your profile will be similar to the
if [ -f /home/db2user/sqllib/db2profile ]; then ./home/db2user/sqllib/db2profile fi
- Your database administrator must back up IBM Cognos Analytics databases regularly because they contain the IBM Cognos data. To ensure the security and integrity of databases, protect them from unauthorized or inappropriate access.