Suggested settings for creating the content store in IBM Db2 on z/OS

To ensure a successful installation, use the following guidelines when creating the content store.

Use the following checklist to help you set up the content store in Db2 on z/OS®.

• Log on to the z/OS system as a user with System Administrator (SYSADM) or System Control (SYSCTRL) privileges in Db2 to create the database.
• Create a database instance, storage group, and a user account for the content store.

  IBM® Cognos® Analytics uses the credentials of the user account to communicate with the database server.

• Ensure that you reserve a buffer pool with a page size of 32 KB, and a second one with a page size of 4 KB for the database instance.
• Administrators must run a script to create table spaces to hold Large Objects and other data for the content store and grant user rights to the table spaces. For information about running the script, see Creating tablespaces for a content store on IBM Db2 for z/OS.
• Your database administrator must back up the content store regularly because it contains the IBM Cognos data application and security information. To ensure the security and integrity of the content store database, protect it from unauthorized or inappropriate access.