Suggested settings for creating a notification database on IBM Db2 on z/OS
The database you create for the notification
database must contain the specified configuration settings.
To ensure a successful installation, use the following guidelines when creating the notification database.
Use the following checklist to help you help you set up the notifications database in Db2 on z/OS®.
- Create a database instance, storage group, and a user account
for the notification database.
A user must have permissions to create and delete tables in the database.
IBM® Cognos® Analytics uses the credentials of the user account to communicate with database server.
- Ensure you reserve a buffer pool with a page size of 32 k, and a second one with a page size of 4 k for the database instance.
- Administrators must run a script to create tablespaces to hold
Large Objects and other data for the notification database to use
the tablespaces.
For information about running the script, see Creating tablespaces for a notification database on IBM Db2 for z/OS.
- 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.