Guidelines for creating a logging database
- Create a logging database.
For IBM® Db2®, Oracle, Microsoft™ SQL Server, use the same procedure that was used to create the content store database. Use the instructions in Guidelines for creating the content store.Note: If you are using Db2, you cannot generate a script to create the notification database in the same way as you can the content store.
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 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.