Creating and populating the database for the dynamic domain manager

Instructions for creating and populating the IBM® Workload Scheduler database for the dynamic domain manager

About this task

This graphic describes the current step: creating and populating the database for the dynamic domain manager.

The procedure for creating the database for the dynamic domain manager is identical to that of the master domain manager, with the exception that an additional parameter, component_type, must be passed to the script.

For the complete procedure for creating and populating the database, see Creating and populating the database, then select the procedure related to the database you are using.

To create the database for the dynamic domain manager submit the following command:
On Windows operating systems
cscript configureDb.vbs --componenttype DDM --rdbmstype db_type 
--dbhostname db_hostname --dbport db_port --dbname db_name 
-–dbuser db_user --dbadminuser db_administrator 
--dbadminuserpw db_administrator_password
On UNIX operating systems
./configureDb.sh --componenttype DDM --rdbmstype db_type 
--dbhostname db_hostname --dbport db_port --dbname db_name 
-–dbuser db_user --dbadminuser db_administrator 
--dbadminuserpw db_administrator_password
where:
--componenttype
The IBM® Workload Scheduler for which the database is installed. When installing a dynamic domain manager, specify DDM.
--rdbmstype|-r rdbms_type
The database type. Supported databases are:
  • DB2
  • ORACLE This value applies to Oracle and Amazon RDS for Oracle
  • MSSQL This value applies to MSSQL and MSSQL cloud-based databases.
  • POSTGRESQL
This parameter is required and has no default value.
--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 IBM® Workload Scheduler database. Note that this name must match the name specified in the serverinst command. For more information about the serverinst command, see Server components installation - serverinst script. When creating the database on Oracle, this parameter indicates the service name.
--dbuser db_user
The user that has been granted access to the IBM® Workload Scheduler tables on the database server.
--dbpassword db_password
(Oracle DB only) The password for the user that has been granted access to the IBM® Workload Scheduler tables on the database server.
--dbadminuserdb_admin_user
The database administrator user that creates the IBM® Workload Scheduler schema objects on the database server.
--dbadminuserpw db_admin_password
The password of the DB administrator user that creates the IBM® Workload Scheduler schema objects on the database server.
The same criteria apply when creating the database for all supported databases. For more information about creating the database for each supported vendor, see:

Results

You have now successfully created and populated the IBM® Workload Scheduler database.

What to do next

You can now proceed to Creating the IBM Workload Scheduler administrative user.