Creating and populating the database for MSSQL cloud-based databases for the Dynamic Workload Console

Instructions for creating and populating the Dynamic Workload Console database for MSSQL cloud-based databases.

About this task

This picture describes the steps required for installing the Dynamic Workload Console. You are now at step 3: creating and populating the Dynamic Workload Console database
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.

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. Default values are stored in the configureDbMSSQL.properties file, located in image_location.

To create the Dynamic Workload Console database and schema, perform the following steps:

Procedure

  1. Specify the path to the folder when running the configureDb command or when filling in the configureDbMSSQL.properties properties file with the following parameter:
    • --iwstsname PRIMARY
    You can optionally modify the PRIMARY default value when running the configureDb command.
  2. On the server where you plan to install the Dynamic Workload Console, extract the Dynamic Workload Console package to a directory of your choice.
  3. To populate the Dynamic Workload Console 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
    iwstsname DATA_tablespace_name

    The name of the tablespace for Dynamic Workload Console data.

    Note: The following parameters specified with the configureDb command are also required when installing the Dynamic Workload Console and their values must be the same:
    • rdbmstype
    • dbhostname
    • dbport
    • dbname
    • dbuser

Results

You have now successfully created and populated the Dynamic Workload Console database.

What to do next

You can now proceed to Installing a Dynamic Workload Console server.