Setting up multiple connections to the database repository

In Cognos Analytics, you can add multiple connections to the IBM Spectrum Control data source so that you can run reports against multiple IBM Spectrum Control databases (TPCDBs).

Before you begin

If your IBM Spectrum Control database is on a different computer than the computer where you installed Cognos Analytics, you must catalog the node and database for the remote IBM Spectrum Control database before you create the Cognos Analytics data source for the IBM Spectrum Control database.

About this task

If you create multiple connections, you can run reports for multiple IBM Spectrum Control servers from one Cognos Analytics server. You can also develop and test reports on multiple TPCDB databases in your storage environment.

After you add multiple connections to the TPCDB data source, when you run a report you select the TPCDB database to connect to.

Procedure

  1. Go to the URL for your Cognos Analytics server. The format of the URL is similar to this URL: http://myhostname:9300/bi
  2. In the Welcome portal, click Manage > Administration console .
  3. In the Configuration tab, click Data Source Connections.
  4. Click the TPCDB data source.
  5. On the toolbar, click the New Connection icon Image shows the New Connection icon..
  6. On the Specify a name and description page, type a name for the new connection in the Name field and then click Next.
    Do not use TPCDB as the name for the new connection because that conflicts with the existing TPCDB connection.
  7. On the Specify the connection page, select IBM DB2 from the Type list.
  8. Verify that Use the default object gateway is selected.
  9. Clear Configure JDBC connection then click Next.
  10. On the Specify the IBM DB2 connection string page, in the DB2 database name property, enter the alias value that you used when you cataloged the remote database.
    For example, enter the value remDB.
  11. In the Signon section, do the following:
    1. Verify that Signons is selected.
    2. Click Password.
    3. In the User ID property, enter the user name of the owner of the DB2® instance where the IBM Spectrum Control database is located.
      On Windows operating systems, this user name is typically db2admin. On Linux® or AIX® operating systems, this user name is typically db2inst1.
    4. In the Password and Confirm password properties, enter the password that is associated with the User ID property in 11.c.
  12. In the Testing section, click Test the connection.
  13. On the Test the connection page, click Test.
  14. When the test is successful, click Close on the View the results page.
  15. On the Test the connection page, click Close.
  16. On the Specify the IBM DB2 connection string page, click Next.
  17. On the Specify the commands page, click Finish.
  18. If you scheduled reports, modify the parameters of all scheduled reports to specify the database against which to run the report.