Creating and populating the database for Azure SQL for the Dynamic Workload Console
Instructions for creating and populating the Dynamic Workload Console database for Azure SQL
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. If you need to modify any of the default values, edit the configureDbMSSQLdatabase_vendor.properties file, but do not modify the configureDbMSSQLdatabase_vendor.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
-
Specify the path to the folder when running the configureDb
command or when filling in the configureDbMSSQL.properties
properties file with the following parameter:
- --iwstname PRIMARY
PRIMARY
default value when running the configureDb command. - On the server where you plan to install the Dynamic Workload Console, extract the Dynamic Workload Console package to a directory of your choice.
-
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
- 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
- --rdbmstype
- The database vendor.
- --dbname db_name
- The name of the HCL Workload Automation database.
- --dbhostname db_hostname
- The host name or IP address of 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.
- --iwstsname|-tn table_space_name
- The name of the tablespace for HCL Workload Automation data. This parameter is required.
Results
You have now successfully created and populated the Dynamic Workload Console database.
What to do next
You can now proceed to Creating the HCL Workload Automation administrative user.