Tivoli Workload Automation, Version 9.2

Procedure to create the dynamic workload broker SQL tables for DB2

The procedure to create the dynamic workload broker database.

To create the dynamic workload broker database, run the following command:

On Windows operating systems:

Log on as Administrator and run:

createdb_root.bat 
<TWS_DB> <TWS_CLIENT_INSTALLATION> 
<TWS_NODE_NAME> <TWS_HOST> 
<TWS_SRVC_PORT> <TWS_ADMIN_USER> 
<TWS_ADMIN_PW> <TWS_INSTANCE>
<TWS_AGENT_TYPE> <IS_CHECK_ONLY>

On UNIX and Linux operating systems:

Log on as root or database administrator and run:

createdb_root.sh 
<TWS_DB> <TWS_CLIENT_INSTALLATION> 
<TWS_NODE_NAME> <TWS_HOST> 
<TWS_SRVC_PORT> <TWS_ADMIN_USER> 
<TWS_ADMIN_PW> <TWS_INSTANCE>
<TWS_AGENT_TYPE> <IS_CHECK_ONLY>

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_CLIENT_INSTALLATION>

The DB2 you are using is client or server. Valid values are true for the client installation and false for the server installation. The default is false.

<TWS_NODE_NAME>

The name of the DB2 node. The node value is <TWS_DB>_ND. The default is TWS_ND.

<TWS_HOST>

The IP address or host name of the workstation where the DB2 server is installed.

<TWS_SRVC_PORT>

The TCP/IP port number that the remote DB2 server instance uses to communicate.

<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.

<TWS_INSTANCE>

The DB2 instance name. The default is DB2.

<TWS_AGENT_TYPE>

The Tivoli Workload Scheduler agent type to specify:

Master domain manager:: MDM
Backup master domain manager:: BKM
Dynamic domain manager:: DDM
Backup dynamic domain manager:: BDM

<IS_CHECK_ONLY>

Always specify FALSE.