Creating the database for Amazon RDS for DB2 for the master domain manager

Instructions for creating and populating the HCL Workload Automation database for Amazon RDS for DB2 for the master domain manager.

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 HCL Workload Automationdatabase

You can create and populate the database as described in the following scenarios, or you can customize the database parameters, as described in FAQ - Database customizations.

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

You can run the configureDb command specifying a typical set of parameters. In this case, default values are used for all remaining parameters.

Default values are stored in the configureDb<database_vendor>.properties file, located in image_location/TWS/interp_name. For an example of a properties file, see What is the content of a database properties file?.

If you need to modify any of the default values, edit the configureDb<database_vendor>.properties file, but do not modify the configureDb<database_vendor>.template file located in the same path.

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 certificates when Db2 or PostgreSQL is in SSL mode?.

To create and populate the HCL Workload Automation database and tables, perform the following steps:

Procedure

On the workstation where you plan to install the master domain manager, extract the HCL Workload Automation package to a directory of your choice.
Browse to the image_location/TWS/interp_name/Tivoli_MDM_interp_name/TWS/tws_tools path.
Connect to rdsadmin database using the system user you created.

Run the following stored procedure to create the database:

call rdsadmin.create_database('db_name', '8192', 'UTF-8', 'US', 'SYSTEM', '', 'N');

Run the following stored procedures to create the buffer pools:
```
call rdsadmin.create_bufferpool('db_name', 'TWS_BUFFPOOL', 500, 'Y', 'N', 16384)
call rdsadmin.create_bufferpool('db_name', 'TWS_BUFFPOOL_TEMP', 500, 'Y', 'N', 16384)
call rdsadmin.create_bufferpool('db_name', 'TWS_PLN_BUFFPOOL', 51200, 'Y', 'N', 16384)
```
Note: The stored procedures on Amazon RDS are asynchronous and return control immediately while the provisioning process runs in the background. Ensure the resources are fully ready for operational use before launching subsequent commands.
To verify if the buffer pools are created, run the following command:
```
SELECT BPNAME, PAGESIZE, NPAGES FROM SYSCAT.BUFFERPOOLS;
```
Run the following stored procedures to create the tablespaces:
```
call rdsadmin.create_tablespace('db_name', 'TWS_DATA', 'TWS_BUFFPOOL', 16384)
call rdsadmin.create_tablespace('db_name', 'TWS_LOG', 'TWS_BUFFPOOL', 16384)
call rdsadmin.create_tablespace('db_name', 'TWS_PLAN', 'TWS_BUFFPOOL', 16384)
```
Note: The stored procedures on Amazon RDS are asynchronous and return control immediately while the provisioning process runs in the background. Ensure the resources are fully ready for operational use before launching subsequent commands.
To verify if the tablespaces are created, run the following command:
```
SELECT TBSPACE, PAGESIZE, BUFFERPOOLID FROM SYSCAT.TABLESPACES;
```
Connect to the created database and run the following command to create and populate the HCL Workload Automation 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_administrator 
--dbadminuserpw DB_administrator_password
```
On UNIX operating systems
```
./configureDb.sh --rdbmstype DB2 --dbhostname DB_hostname 
--dbport db_port --dbname db_name --dbuser db_user
--dbadminuser DB_administrator 
--dbadminuserpw DB_administrator_password
```
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 HCL Workload Automation database.

--dbuser db_user

The database user you must create before running the configureDb command.

--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.
Note: The following parameters are also required when installing the master components and their values must be the same:
- --rdbmstype
- --dbhostname
- --dbport
- --dbname
- --dbuser

Results

You have now successfully created and populated the HCL Workload Automation database.

What to do next

You can now proceed to Creating the database for Amazon RDS for DB2 for the Dynamic Workload Console.