Updating the connection to the OpenPages database for Cognos (Db2)

Applies to: On premises

If you are using new hardware for the database server, update Cognos® with the database connection information for the OpenPages® database.

Procedure

  1. Start the IBM® Cognos services.
  2. Log on to IBM Cognos Analytics as a user with administrative privileges by doing one of the following steps:
    • In OpenPages, click Analytics.
    • Or, go to the following URL: http://<hostname>/ibmcognos/bi

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

  3. Click Manage > Administration Console to launch the IBM Cognos Administration page.
  4. Click the Configuration tab.
  5. Click OpenPages DataSource under Data Source Connections.
  6. Click Actions > Set Properties - OpenPages DataSource.
  7. Update the database connection string:
    1. Click the Connection tab.
    2. Click the pencil icon next to the Connection String box to edit the field.
    3. On the CLI tab, in the Db2 database name box, change the Db2® database name to the Catalog Database Name of the OpenPages database in your upgraded environment.