Creating a logging database

You can store log messages in a logging database.

Tip: Logging database is also referred to as audit database.

Creating a logging database includes the following tasks:

Create the database.
Use the instructions in Guidelines for creating the content store.

For Db2®, you cannot generate a script to create the logging database in the same way as you can create the content store database.

For Db2 on z/OS®, use the instructions in Suggested settings for creating a logging database on Db2 on z/OS.
Set up the database connectivity.
Use the instructions in Set up database connectivity for the logging database.
Specify the log messages repository.
Use the instructions in Log message repositories.

Suggested settings for creating a logging database on Db2 on z/OS

The database you create must contain the specified configuration settings.

Use the following checklist to help you set up the logging database on Db2 on z/OS.

Log on to the z/OS system as a user with administrator privileges on Db2 on z/OS.
Create a database instance, storage group, and a user account for the content store. IBM® Cognos® uses the credentials of the user account to communicate with the database server.
Ensure that you allocate a buffer pool with a page size of 8 KB for the database instance.
For a logging database on Db2 on z/OS, administrators must run a tablespace script to create tablespaces to hold large objects and other data for the logging database, and then grant user rights to the table. For information about running the tablespace script, see Create tablespaces for a logging database on Db2 on z/OS.