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
- Create a database using the same instructions as Guidelines for creating the content store.
- Create a user account that will be used to operate the database.
- For the instance where the Application Tier Components are installed, start IBM Cognos Configuration.
- In the Explorer, right-click Human Task and Annotation Services and select New resource > Database.
- In the New Resource - Database dialog box, type a name for the database, select the type, and then click OK.
- 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.
- From the File menu, click Save.
The logon credentials are immediately encrypted.
- To test the connection to the new database, from the Actions menu, click Test.
- Repeat these steps on each Application Tier Components and Content Manager instance.