Creating the database for OneDB for the master domain manager
Instructions for creating and populating the HCL Workload Automation database for OneDB for the master domain manager on UNIX operating systems. Both the database and the master domain manager must reside on UNIX operating systems.
Before you begin
- A db space sized 100 MB and with a page size of 8K or greater. When you run the
configureDb command, as described below, specify this db
space for the following parameters:
iwstsname
iwslogtsname
iwsplantsname
- An sb space for blob and clob data, sized 100 MB. When you run the
configureDb command, as described below, specify this sb
space for the
iwssbspace
parameter.
About this task
You can perform a typical database procedure, as described in the following scenarios, or you can customize the database parameters, as described in FAQ - Database customizations.
You can run the configureDb command specifying a typical set of parameters. In this case, default values are used for all remaining parameters.
For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDB script.
Default values are stored in the configureDbIds.properties file, located in image_location/TWS/interp_name.
If you need to modify any of the default values, edit the configureDbIds.properties file, but do not modify the configureDbIds.template file located in the same path.
To create the HCL Workload Automation database and schema, perform the following steps:
Procedure
- On the server where you plan to install the master domain manager, extract the HCL Workload Automation package to a directory of your choice.
- Browse to image_location/TWS/interp_name.
-
Type the following command to populate the HCL Workload Automation database
with typical settings:
- On UNIX operating systems
-
./configureDb.sh --rdbmstype ONEDB --dbname db_name -–dbuser db_user --dbhostname db_hostname --dbadminuser db_administrator --dbadminuserpw db_administrator_password
- --rdbmstype
- The database vendor.
- --dbhostname db_hostname
- The host name or IP address of database server.
- --dbport db_port
- The port of the database server.
- --dbname db_name
- The name of the HCL Workload Automation database.
- dbuser db_user
- The user to be granted access to the HCL Workload Automation tables on the database server.
- --dbadminuser db_admin_user
- The database administrator user that creates the HCL Workload Automation schema objects on the database server.
- --dbadminuserpw db_admin_password
- The password of the DB administrator user that creates the HCL Workload Automation schema objects on the database server. Special characters are not supported.
Note: The following parameters specified with the configureDb command are also required when installing the server components and their values must be the same:- rdbmstype
- dbhostname
- dbport
- dbname
- dbuser
Results
You have now successfully created and populated the HCL Workload Automation database.
You can now proceed to Creating the database for OneDB for the Dynamic Workload Console.