HCL Workload Automation, Version 9.4

Procedure to create the dynamic workload broker SQL schema on Informix

To create the dynamic workload broker database, run 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. For more information about how to customize the property file, see Customizing the properties file for Informix Dynamic Server.
Run the following command:
```
createdb_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. The default value is TWS.

<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 created:
MDM

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

BKM

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

DDM

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

BDM

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

<TWS_DBSP_NAME>

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