IBM Tivoli Composite Application Manager for Applications, Version 7.2.1.1

Authorizing the user ID for DB2 database

If you want to use a DB2 Universal Database™ as the configuration database, before setting up the configuration database, the DB2® instance owner must have created a database and granted permissions to the user ID that is used to run the hub monitoring server.

About this task

To create the user ID and grant permissions, perform the following steps:

Procedure

  1. Log on to DB2 with the user ID of the DB2 instance owner. If you logged on using another user ID, you can run the following command to change to the user ID of the DB2 instance owner:
    su db2_user_ID
    where db2_user_ID is the user ID of the DB2 instance owner.
  2. Start the DB2 command line processor by running the following command:
    db2
  3. Run the following commands to create the database and grant permissions to the user ID that is used to run the hub Tivoli® Enterprise Monitoring Server:
    Important: If you are using a 64-bit version of DB2 version 8, you must create a 32-bit database instance for the configuration database. 64-bit database instances are supported from DB2 version 9 onwards. See your DB2 documentation for more information.
    CREATE DATABASE RKCFAPLT
    CONNECT TO RKCFAPLT 
    GRANT CONNECT ON DATABASE TO USER tems_user_ID 
    GRANT CREATETAB ON DATABASE TO USER tems_user_ID
    where tems_user_ID is the user ID that is used to run the hub monitoring server.


Feedback