Setting database connection properties for a IBM Db2 content store

You must specify the database server information to ensure that Content Manager can connect to the database you use for the content store.

Procedure

  1. In the location where you installed Content Manager, start IBM® Cognos® Configuration.
  2. In the Explorer window, under Data Access, Content Manager, click Content Store.
  3. In the Properties window, for the Database name property, type the name of the database or the database alias.
  4. Change the logon credentials to specify a valid user ID and password:
    • Click the Value box next to the User ID and password property and then click the edit button when it appears.
    • Type the appropriate values and click OK.
  5. In the Database server and port number field, enter the name of your computer and port number on which Db2® is running. For example, localhost:50000. 50000 is the default port number used by Db2. If you are using a different port number, ensure you use that value.
  6. From the File menu, click Save.
  7. To test the connection between Content Manager and the content store database, from the Actions menu, click Test.

    Content Manager connects to the database, checks the database permissions, and creates and populates a table. The table is not deleted and is used each time that the test is repeated.