Granting permissions for stored procedures for HCL DB2

Before you configure stored procedures for HCL® DB2®, you must grant permissions.

About this task

To grant permissions, complete the following steps.

Procedure

  1. Enable the registry by completing the following steps:
    1. Set the DB2_ATS_ENABLE registry variable to one of the following values:
      • YES
      • TRUE
      • 1
      • ON
    2. Restart the DB2 database after you set the variable.
  2. Create the SYSTOOLSPACE table space.

    Users who belong to the SYSADM or SYSCTRL group can create this space. Use the following query to verify that the space exists:

    SELECT TBSPACE FROM SYSCAT.TABLESPACES WHERE TBSPACE = 'SYSTOOLSPACE'
  3. Grant permissions. In the following examples, substitute the values that are appropriate for your environment.
    • EMESSAGE: Database that contains the eMessage system tables
    • USER1: Owner of the EMESSAGE database
    • DB2ADMIN: DB2 administrative user
    • Administrator: Super user
  4. Connect to DB2 as an administrative user and run the following grant commands:
    • db2 GRANT DBADM ON DATABASE TO USER DB2ADMIN
    • db2 GRANT DBADM ON DATABASE TO USER USER1
    • db2 grant all on table SYSTOOLS.ADMINTASKS to USER1
    • db2 grant all on table SYSTOOLS.ADMINTASKS to DB2ADMIN
  5. If the SYSPROC.ADMIN_TASK_ADD table exists, run the following grant commands:
    • db2 grant execute on procedure SYSPROC.ADMIN_TASK_ADD to USER1
    • db2 grant execute on procedure SYSPROC.ADMIN_TASK_ADD to DB2ADMIN