Configuring the content store for Cognos Analytics

The Cognos® Analytics content store is a database that is used to store configuration data, global settings, data server connections, and product-specific content.

1. In IBM Cloud Pak for Data, click My instances, and open the details for the provisioned IBM Db2 instance.
2. Collect the following details:
   • Database name
   • Deployment id
   • Username
   • Password
   • JDBC Connection URL
3. Log in to your Red Hat® OpenShift® cluster:

   oc login OpenShift_URL:port

4. Open a terminal window and enter the following commands.

   #
   #  USE VALUES from STEP 2
   #
   export NAMESPACE=<Namespace of your CPD Installation>
   export DB2USERNAME=<USERNAME>
   export DB2PASSWORD=<PASSWORD>
   export DB2DEPLOYMENTID=<DEPLOYMENTID>
   
    
   #
   # Connect to DB2U Pod
   #
   export CMD="env DB2USERNAME=$DB2USERNAME DB2PASSWORD=$DB2PASSWORD  bash"
   oc  exec -ti c-$DB2DEPLOYMENTID-db2u-0 -n $NAMESPACE -- $CMD
   

5. From the Db2 container, enter the following commands in your terminal window:

   cd /mnt/blumeta0/home/db2inst1/sqllib
   . ./db2profile   
    
   db2 CONNECT to BLUDB user $DB2USERNAME using  $DB2PASSWORD 
   db2 UPDATE DATABASE CONFIGURATION USING APPLHEAPSZ 1024 DEFERRED; 
   db2 UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED;
   db2 CREATE BUFFERPOOL CMDB_08KBP IMMEDIATE SIZE 1000 PAGESIZE 8K;
   db2 CREATE BUFFERPOOL CMDB_32KBP IMMEDIATE SIZE 1000 PAGESIZE 32K;
   db2 CREATE SYSTEM TEMPORARY TABLESPACE TSN_SYS_CMDB IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32K BUFFERPOOL CMDB_32KBP;
   db2 CREATE USER TEMPORARY TABLESPACE TSN_USR_CMDB IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K BUFFERPOOL CMDB_08KBP;
   db2 CREATE REGULAR TABLESPACE TSN_REG_CMDB IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K BUFFERPOOL CMDB_08KBP; 
   db2 CREATE SCHEMA db2COGNOS AUTHORIZATION $DB2USERNAME;
   db2 ALTER BUFFERPOOL ibmdefaultbp size 49800
   
   exit
   

   Your database is created. Complete the next steps to connect to a data source.

6. To connect to a IBM Db2 Database, Microsoft SQL Server, or Oracle data source:
   Note: IBM Db2 Warehouse database is currently not a supported data source.
   1. Log in to the Cloud Pak for Data web client.
   2. From the menu, select Connections.
   3. Click New connection.
   4. Enter a name and a description for the connection.
   5. Select Db2, Microsoft SQL Server, or Oracle for the Connection type.
   6. On the New connection page, enter the connection information. For example:
      • Host
      • Port
      • Database name
      • Username
      • Password
7. To test the connection, click Test connection on the New connection page.
8. Click Create.
   The connection is saved.