Creating and populating the database for DB2 for the Dynamic Workload Console

Instructions for creating and populating the Dynamic Workload Console database for DB2

Before you begin

Ensure a DB2 database is installed.

About this task

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

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.

DB2 requires a specific procedure in which you first create the database and then create and populate the database tables. To simplify the database creation, a customized SQL file named create_database.sql is provided containing the specifics for creating the Dynamic Workload Console database. The database administrator can use this file to create the database. After the database has been created, you can proceed to create and populate the database tables.

You can optionally configure DB2 in SSL mode on UNIX operating systems by specifying the sslkeysfolder and sslpassword parameters when you run the configureDb command. For more information, see How can I use default certificates when DB2 is in SSL mode?

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 configureDb.properties file, located in image_location. If you need to modify any of the default values, edit the configureDbdatabase_vendor>.properties file, but do not modify the configureDbdatabase_vendor>.template file located in the same path.

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

Procedure

On the workstation where you plan to install the Dynamic Workload Console, extract the Dynamic Workload Console package to a directory of your choice.
Browse to the image_location/DWC_interp_name/tools path.
Edit the create_database.sql file by replacing the default value for the database name (DWC) with the name you intend to use.
Provide the create_database.sql file to the DB2 administrator to run on the DB2 database.
The following command creates the HCL Workload Automation database:
```
db2 -tvf <file_location>/create_database.sql
```
Instruct the DB2 administrator to create the DB2 user on the server hosting the DB2 database. You will then specify this user with the dbuser parameter when creating and populating the database with the configureDb command on the Dynamic Workload Console. When you run the configureDb command, this user is automatically granted access to the Dynamic Workload Console tables on the database server.
On the server where you plan to install the Dynamic Workload Console,browse to image_location/DWC_interp_name.
Type the following command to create and populate the Dynamic Workload Console database tables with typical settings:
On Windows operating systems
```
cscript configureDb.vbs --rdbmstype DB2 --dbhostname DB_hostname 
        --dbport db_port --dbname db_name --dbuser db_user 
        --dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
```
On UNIX operating systems
```
./configureDb.sh --rdbmstype DB2 --dbhostname DB_hostname 
        --dbport db_port --dbname db_name --dbuser db_user 
        --dbadminuser DB_admin_user --dbadminuserpw DB_admin_pwd
```
where:

--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 Dynamic Workload Console database.

--dbuser db_user

The database user you must create before running the configureDb command. You need to run a similar script as grant_twsuser.sql to give the proper rights to the dbuser.

--dbadminuser db_admin_user

The database administrator user that creates the Dynamic Workload Console schema objects on the database server.

--dbadminuserpw db_admin_password

The password of the DB administrator user that creates the Dynamic Workload Console schema objects on the database server.
Note: The following parameters specified with the configureDb command are also required when installing theDynamic 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.

For more information about all parameters and supported values of the configureDb command, see Database configuration - configureDB script.

What to do next

You can now proceed to Creating the HCL Workload Automation administrative user.