Tivoli Workload Automation, Version 9.2

Procedure to upgrade the dynamic workload broker SQL tables for DB2

The procedure to upgrade the dynamic workload broker database.

To upgrade the dynamic workload broker database, run the following command:
On Windows operating systems:
Log on as Administrator and run:
migratedb_root.bat 
<TWS_DB_ALIAS> <TWS_DB2ADMIN_USER> 
<TWS_DB2ADMIN_PASSWORD> <TWS_IS_DDM>
<TWS_IS_BDM>
On UNIX and Linux operating systems:
  1. Log on as root or database administrator
  2. Go to the following directory:
    TWSTEMPDIR/TDWB/dbtools/db2/scripts
    Run the following:
    dbmigrate.sh <TWS_DB_ALIAS> 
    <TWS_DB2ADMIN_USER>
    <TWS_DB2ADMIN_PASSWORD>
    <TWS_IS_DDM><TWS_IS_BDM>
Where:
<TWS_DB_ALIAS>
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_DB2ADMIN_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 operating 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_DB2ADMIN_PASSWORD>
The password of the DB2 server administrator user, or of the user with SYSADM or SYSCTRL authority.
<TWS_IS_DDM>
Specify if the Tivoli Workload Scheduler agent is a dynamic domain manager. Possible values are TRUE or FALSE.
Note: If you are managing a master domain manager or a backup dynamic domain manager, set the value to FALSE.
<TWS_IS_BDM>
Specify if the Tivoli Workload Scheduler agent is a backup dynamic domain manager. Possible values are TRUE or FALSE.
Note: If you are managing a master domain manager or a dynamic domain manager, set the value to FALSE.