Using Cognos Analytics with multiple remote IBM Spectrum® Control databases

You can configure multiple connections within a single Cognos Analytics data source to use Cognos Analytics with multiple remote IBM Spectrum Control databases.

To rename the TPCDB connection and to create more connections to other remote IBM Spectrum Control databases within the single data source, complete the following steps:

1. Open a web browser and enter the following URL:

   http://FQDN_Of_Your_Machine:9300/bi

   Where http is the protocol, and FQDN_Of_Your_Machine is your fully qualified domain name, (for example, myserver.mycompany.com) of the machine where you installed Cognos Analytics.

2. Select Manage > Administration console.
3. In the IBM Cognos Administration GUI, select the Configuration tab.
4. In the Configuration tab, select Data Source Connections.
5. On the Data Source Connections page, click the TPCDB data source. This action will drill down one level and you will see the TPCDB connection.
6. In Actions, click the Set properties - TPCDB icon; it's the first icon in the list.
7. On the Set properties - TPCDB page, change the Name value from TPCDB to a value that reflects the particular IBM Spectrum Control database that this connection uses (for example, scserv1).
8. Click OK.
   You are returned to the Data Source Connections page and your first data source has been renamed.
9. On the Data Source Connections page, in the toolbar, click the New Connection icon. It's the first icon in the list.
10. On the Specify a name and description - New Connection page, in the Name property, enter a value that reflects the particular IBM Spectrum Control database that this connection will use (for example, myserv2).
11. On the Specify a name and description - New Connection page, click Next.
12. On the Specify a name and description - New Connection page, select IBM Db2 from the Type field.
13. Verify that Use the default object gateway is selected.
14. Unmark Configure JDBC connection and click Next.
15. On the Specify the IBM Db2 connection string - New Connection page, in the DB2 database name property, enter the alias value that you created when you cataloged a particular remote IBM Spectrum Control database.
16. On the Specify the IBM Db2 connection string - New Connection page, in the Signon section, do the following:
    1. Verify that Signons is selected.
    2. Select Password.
    3. In the User ID property, enter the user name of the owner of the Db2® instance where the remote IBM Spectrum Control database is located. Note: On a Windows operating system, 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 value from the previous substep.
17. On the Specify the IBM Db2 connection string - New Connection page, in the Testing section, click Test the connection.
18. Click Test.
19. When the test is successful, on the View the results page, click Close.
20. On the Test the connection - New Connection page, click Close.
21. On the Specify the IBM Db2 connection string - New Connection page, click Next.
22. On the Specify the commands - New Connection page, click Finish.