Setting database connection properties for a content store on IBM Db2® for z/OS®

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 icon when it appears. Ensure that you specify the same user ID as the value you specified for CMSCRIPT_USERNAME when you created the tablespaces.
    • Type the appropriate values, and click OK.
  5. For the Database server and port number property, type the database information as hostname:port.
  6. In the Explorer window, click Local Configuration.
  7. Click inside the Value box for Advanced properties, and then click the edit icon.

    The Value - Advanced properties dialog box appears.

  8. Click Add to add the parameters for the database connection.

    The values in the table are examples, ensure that you enter the correct values for your environment.

    Table 1. Content store connection parameters for Db2 for z/OS
    Parameter name Example value
    CMSCRIPT_CREATE_IN COGUCS.T1TSCS
    CMSCRIPT_STOGROUP DBOIUSR
    CMSCRIPT_DATABASE COGUCS
    CMSCRIPT_CS_ID T1
    CMSCRIPT_TABLESPACE TSCS
    CMSCRIPT_LARGE_BP BP32K
    CMSCRIPT_REGULAR_BP BP16K0
  9. Click File > Save.
  10. To test the connection between Content Manager and the content store database, from the Actions menu, click Test.