Setting up a database for Human Tasks and Annotations

By default, the data used for the Human Tasks and Annotations feature in IBM® Cognos® Workspace is stored in the same database as the content store. You can configure a separate database for Human Tasks and Annotations.

To set up the database, you must first create the database, create a user account under which the database will operate, and then configure the Human Tasks and Annotations feature to use the new database.

Procedure

  1. Create a database using the same instructions as Guidelines for creating the content store.

    If you are using IBM Db2 on z/OS for your database, you must create the required tablespaces by running two scripts. For more information, see Creating tablespaces for the human task and annotation database on IBM Db2 on z/OS.

  2. Create a user account that will be used to operate the database.
  3. For the instance where the Application Tier Components are installed, start IBM Cognos Configuration.
  4. In the Explorer, right-click Human Task and Annotation Services and select New resource > Database.
  5. In the New Resource - Database dialog box, type a name for the database, select the type, and then click OK.
  6. In the database resource properties window, configure the following:
    • Specify the mandatory values for all properties that are marked with an asterisk.
    • Specify the User ID and password for the account that operates the database.
  7. From the File menu, click Save.

    The logon credentials are immediately encrypted.

  8. To test the connection to the new database, from the Actions menu, click Test.
  9. Repeat these steps on each Application Tier Components and Content Manager instance.