HCL Workload Automation, Version 9.4

Procedure to upgrade the dynamic workload broker SQL schema on Informix

Before upgrading the dynamic workload broker database, complete the following steps:

Do not change the master domain manager or dynamic domain manager workstation name (the This workstation name field in the master domain manager or dynamic domain manager configuration panel when you install HCL Workload Automation) from the previous installation, otherwise the migration of the database will end with errors. If you want to change this name, do so after the completion of the upgrade process.
If your database is based on a database space less than 8K, before you upgrade the dynamic workload broker schema you must run the following steps to increase the DBSPACE to 8K:
1. Take a LEVEL 0 backup of the database for security.
2. Run the dbexport command to unload the database to a text file while you increase the DBSPACE. Run the command with the -ss option. For example:
```
dbexport -d <tdwb_db_name> -ss -o <path_to_export>
```
3. Run the onspaces command to create a DBSPACE with a page size of at least 8K. For example:
```
onspaces -c -d DBSPNAME -k 8 -p /usr4/dbspaces/DBSPNAME 
         -o 0 -s 80000
```
4. Drop or rename the existing database.
5. Run the dbimport command to recreate the database, making sure you specify the new 8K (or greater) DBSPACE as well as the -ansi option. For example:
```
dbimport <tdwb_db_name> -d DBSPNAME -ansi -l -i <path_of_exported_db>
```

To upgrade the dynamic workload broker database, complete the following steps:

Log on as root on your Linux system and go to the following directory:
```
TWSTEMPDIR/TDWB/dbtools/ids/scripts
```
Where TWSTEMPDIR is the directory you specified in the TWSTEMPDIR property of the configuration file.
Run the following command:
```
migratedb_root.sh 
<TWS_DB> <TWS_HOST>
<TWS_SRVC_PORT> <TWS_DB_USER>
<TWS_DB_PW> <TWS_AGENT_TYPE>
<TWS_DBSP_NAME>
```
Where:
<TWS_DB>

The name of the database that you are upgrading.

<TWS_HOST>

The IP address or host name of the workstation where Informix Dynamic Server is installed.

<TWS_SRVC_PORT>

The TCP/IP port number that the remote Informix Dynamic Server instance uses to communicate.

<TWS_DB_USER>

The user name of the database administrator that has access to the HCL Workload Automation schema on the database.

<TWS_DB_PW>

The password of the database administrator user. It must comply with the Informix Dynamic Server naming rules.

<TWS_AGENT_TYPE>

Specify the HCL Workload Automation workstation type where the database is being upgraded:
MDM

The dynamic workload broker database is to be upgraded on the master domain manager.
Attention: Start this procedure only after the master domain manager database is upgraded.

BKM

The dynamic workload broker database is to be upgraded on the backup master domain manager.
Attention: Start this procedure only after the backup master domain manager database is upgraded.

DDM

The dynamic workload broker database is to be upgraded on a dynamic domain manager.

BDM

The dynamic workload broker database is to be upgraded on a backup domain manager.
Attention: Start this procedure only after the dynamic domain manager database is upgraded.

<TWS_DBSP_NAME>

The name of the db space used to store scheduling objects and event rules.