HCL Workload Automation, Version 9.4

Procedure to upgrade the HCL Workload Automation SQL tables for DB2

The procedure to upgrade the HCL Workload Automation database.

To upgrade the HCL Workload Automation database, perform the following steps:
  1. Log on as Administrator on Windows operating systems and as root on UNIX and Linux operating systems.
  2. Go to the following directory:
    On Windows operating systems:

    TWSTEMPDIR\TWA\tws94\TWS\dbtools\db2\scripts

    On UNIX and Linux operating systems:
    TWSTEMPDIR/TWA/tws94/TWS/dbtools/db2/scripts

    Where TWSTEMPDIR is the directory that you specified in the TWSTEMPDIR property of the configuration file. For more information about how to customize the property file, see Customizing the properties file for DB2.

  3. Run the following command:
    On Windows operating systems:
    migratedb_root.bat 
    <TWS_DB> <TWS_ADMIN_USER> 
    <TWS_ADMIN_PW> 
    On UNIX and Linux operating systems:
    migratedb_root.sh 
    <TWS_DB> <TWS_ADMIN_USER> 
    <TWS_ADMIN_PW> 
    Where:
    <TWS_DB>
    The name of the DB2 database. The maximum length is five characters. You can use an existing DB2® database instance if its name does not exceed five characters. The default is TWS.
    <TWS_ADMIN_USER>
    The user name of the administrator of the DB2 server instance. This user can be any user having SYSADM or SYSCTRL authority on the DB2 server. On UNIX systems, verify that you can switch to this user and that it can load the DB2 environment.
    On Windows operating systems:
    The default value is db2admin.
    On UNIX and Linux operating systems:
    The default value is db2inst1.
    <TWS_ADMIN_PW>
    The password of the DB2 server administrator user, or of the user with SYSADM or SYSCTRL authority.