Creating the database for MSSQL cloud-based databases for the master domain manager

Instructions for creating and populating the IBM® Workload Scheduler database for MSSQL cloud-based databases for the master domain manager.

This picture describes the steps required for installing the master domain manager. You are now at step 3: creating and populating the IBM Workload Schedulerdatabase

MSSQL cloud-based databases include the following:

Azure SQL
Google Cloud SQL for SQL server
Amazon RDS for MSSQL

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 configureDbMSSQL.properties file, located in image_location/TWS/interp_name.

If you need to modify any of the default values, edit the configureDbMSSQL.properties file, but do not modify the configureDbMSSQL.template file located in the same path. For an example of a properties file, see What is the content of a database properties file?.

To create the IBM Workload Scheduler database and schema, perform the following steps:

Specify the path for the tablespaces when running the configureDb command or when filling in the configureDbMSSQL.properties properties file with the following parameters:
- --iwstsname PRIMARY
- --iwslogtsname PRIMARY
- --iwsplantsname PRIMARY
You can optionally modify the PRIMARY default values when running the configureDb command.
On the server where you plan to install the master domain manager, extract the IBM Workload Scheduler package to a directory of your choice.
Browse to image_location/TWS/interp_name.
To populate the IBM Workload Scheduler database with typical settings, type the following command:
On Windows operating systems
```
cscript configureDb.vbs --rdbmstype MSSQL --dbname db_name
--dbhostname db_hostname --dbadminuser db_administrator
--dbadminuserpw db_administrator_password
--iwstsname DATA_tablespace_name
--iwslogtsname LOG_tablespace_name
--iwsplantsname PLAN_tablespace_name
```
On UNIX operating systems
```
./configureDb.sh --rdbmstype MSSQL --dbname db_name
--dbhostname db_hostname --dbadminuser db_administrator
--dbadminuserpw DB_administrator_password
--iwstsname DATA_tablespace_name
--iwslogtsname LOG_tablespace_name
--iwsplantsname PLAN_tablespace_name
```
where:

--rdbmstype

The database vendor.

--dbhostname db_hostname

The host name or IP address of database server.

--dbname db_name

The name of the IBM Workload Scheduler database.

dbuser db_user

The user to be granted access to the IBM Workload Scheduler tables on the database server.

--dbadminuser db_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. Special characters are not supported.

--iwstsname|-tn table_space_name

The name of the tablespace for IBM Workload Scheduler data.

--iwslogtsname|-ln log_table_space

The name of the tablespace for IBM Workload Scheduler log.

--iwsplantsname|-pn plan_table_space

The name of the tablespace for IBM Workload Scheduler plan.

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

You can now proceed to Creating and populating the database for MSSQL cloud-based databases for the Dynamic Workload Console.