Update Db2 database connection references for Cognos

You must update the database connection references for the server on the IBM® Cognos® Analytics.

Procedure

  1. From a browser, log on to IBM Cognos Analytics as a user with administrative privileges, for example, OpenPagesAdministrator.

    By default, the URL is http://<hostname>/ibmcognos/bi

    Where <hostname> is the name of the Cognos server.

  2. Click Manage > Administration Console to launch the IBM Cognos Administration page.
  3. On the Configuration tab, click Data Source Connections (if not already selected).
  4. On the Directory > Cognos page, click the link for the OpenPages DataSource.
  5. On the Directory > Cognos > OpenPages DataSource page, do the following:
    1. Under the Actions column, click the Set properties - OpenPages DataSource icon Set properties icon.
    2. On the Set properties - OpenPages DataSource page, click the Connection tab.
  6. On the Connection tab, next to the Connection String box, click the pencil icon to edit the field.
  7. On the CLI tab, in the DB2 database name box, change the Db2® database name to the Catalog Database Name of the OpenPages® database on the target environment.
  8. On the JDBC tab, in the Server name, Port number, and Database name boxes, change the values to valid values for the OpenPages database on the target environment.