Configuring a connection to the content store (Db2)

Applies to: On premises

After you install IBM® Cognos® Analytics, configure a connection to the content store database.

Important: The content store database must be in a separate database instance than the IBM OpenPages® database. Oracle compatibility mode must not be enabled for the IBM Db2® database instance that is used for the content store.

Before you begin

Ensure that you copied the JDBC database driver files to the <COGNOS_HOME>/drivers directory. For more information, see step 4 in Installing IBM Cognos Analytics.

Procedure

  1. Log on to the reporting server as a user with administrator privileges.
    Note: For Windows installations, the user must belong to the DB2ADMINS group. For Linux® installations, the user must belong to the db2iadm group.
  2. Start Cognos Configuration.
    • On Windows computers, click Start > IBM Cognos Analytics > IBM Cognos Configuration.
    • On Linux, go to the <COGNOS_HOME>/bin64 directory, type ./cogconfig.sh, and press Enter.
  3. In Cognos Configuration, configure the database connection to the content store.
    1. In the Explorer pane, under Data Access > Content Manager, click Content Store.
    2. In the Database server and port number field, enter the name of the computer and the port number on which Db2 is running.

      localhost:50000 is the default setting. 50000 is the default port number that is used by Db2. Replace localhost with the Db2 server name. If you are using a different port number, replace the default port with the port that you are using.

    3. Click the Value field next to the User ID and password property, click the edit icon, and type the appropriate values for the Cognos user that you created for the content store database, and click OK.
    4. In the Properties window, for the Database name property, type the name for your content store database.
      Restriction: Do not use a name longer than eight characters and use only letters, numbers, underscores, and hyphens in the name.
  4. Right-click Content Store, and click Generate DDL.
  5. In the message box, click Details to record the location of the DDL file that is generated.

    The createDb.sql file is created in the <COGNOS_HOME>/configuration/schemas/content/db2 directory.

  6. To save your settings in Cognos Configuration, click File > Save.
  7. To run the script that creates the database, log in to the database server as a user who has permissions to create a database.
    1. For Windows installations, at the command prompt, type db2cmd.
    2. From the command line, type db2 -tvf createDb.sql.
    3. On Windows computers, close the CLP.
  8. In Cognos Configuration, in the Explorer pane, right-click the content store database connection and click Test.