HCL Workload Automation, Version 9.4

Changing the Dashboard Application Services Hub user of DB repository

How to change the Dashboard Application Services Hub user that updates the settings repository on DB2.

Before you begin

You must have switched the Dynamic Workload Console settings repository from a local file to a database repository, as described in Changing settings repository.

About this task

If you want the Dashboard Application Services Hub to access the database repository with a user without database administrator privileges you must follow these steps:

Procedure

  1. Create a new DB2 user and grant this user with CONNECT, CREATETAB, LOAD rights. For example, db2 GRANT CONNECT,CREATETAB,LOAD ON DATABASE TO USER db2user2
  2. On each Dashboard Application Services Hub node, configure the high availability system by following the steps in Setting up a High Availability configuration, changing the parameters in tipha.properties file with the new information.
    For example, if the new database name is tipdb2, you must set the following properties:
    DBName=tipdb2
    DBDatasource=jdbc/tipds2
    DBDatasourceName=tipds2
    HAEnabled=false
  3. Run the ws.ant script specifying the new DB2 user

    For example, ../ws_ant.sh -f install.ant configHA -Dusername=db2user2 -Dpassword=pass