Upgrading the database schema for the dynamic domain manager

Upgrade the dynamic domain manager database schema before upgrading the dynamic domain manager component.

About this task

This graphic describes the current step: upgrading the database for the dynamic domain manager.
Note: Before upgrading the database schema, ensure you have created a backup. Refer to the documentation related to your RDBMS for information about the backup procedure.

You can perform a typical database upgrade procedure as described in the following scenario, 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. The script creates an SQL file with all the statements needed to upgrade the HCL Workload Automation database schema to the latest version and, by default, automatically applies it. Default values are stored in the configureDb.properties file, located in image_location/TWS/interp_name. If you need to modify any of the default values, edit the configureDb.properties file, but do not modify the configureDb.template file located in the same path.

To upgrade the HCL Workload Automation database schema, perform the following steps:

  1. On the workstation where the dynamic domain manager is installed, extract the HCL Workload Automation installation package to a directory of your choice.
  2. Browse to the image_location/TWS/interp_name path.
  3. On the workstation where you will install the new backup dynamic domain manager that will then switch to become the current active dynamic domain manager, type the following command to upgrade the HCL Workload Automation database schema. Ensure that you use the same database administrator credentials you used when the HCL Workload Automation database schema objects were created.
    DB2
    On Windows operating systems
    cscript configureDb.vbs --componenttype DDM --rdbmstype DB2 --dbhostname db_hostname --dbport db_port 
--dbname db_name --dbuser db_user --dbpassword db_password  
--dbadminuser db_administrator --dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan
    On UNIX operating systems
    ./configureDb.sh --componenttype DDM --rdbmstype DB2 --dbhostname db_hostname --dbport db_port 
--dbname db_name --dbuser db_user --dbpassword db_password  
--dbadminuser db_administrator --dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan
    Oracle
    On Windows operating systems
    cscript configureDb.vbs --componenttype DDM --rdbmstype ORACLE --dbname service_name 
-–dbuser db_user --dbpassword db_password --dbhostname db_hostname 
--dbadminuser db_administrator --dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan
    On UNIX operating systems
    ./configureDb.sh --componenttype DDM --rdbmstype ORACLE --dbname service_name 
-–dbuser db_user --dbpassword db_password --dbhostname db_hostname 
--dbadminuser db_administrator --dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan
    Informix
    On UNIX operating systems
    ./configureDb.sh --componenttype DDM --rdbmstype IDS --dbname db_name -–dbuser db_user 
--dbpassword db_password --dbhostname db_hostname --dbadminuser db_administrator 
--dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan
    OneDB
    On UNIX operating systems
    ./configureDb.sh --componenttype DDM --rdbmstype ONEDB --dbname db_name -–dbuser db_user 
--dbpassword db_password --dbhostname db_hostname --dbadminuser db_administrator 
--dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan
    MSSQL
    On Windows operating systems
    cscript configureDb.vbs --componenttype DDM --rdbmstype MSSQL --dbhostname db_hostname --dbport db_port 
--dbname db_name --dbuser db_user --dbpassword db_password  
--dbadminuser db_administrator --dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan 
--auth_type SQLSERVER
    On UNIX operating systems
    ./configureDb.sh --componenttype DDM --rdbmstype MSSQL --dbhostname db_hostname --dbport db_port 
--dbname db_name --dbuser db_user --dbpassword db_password  
--dbadminuser db_administrator --dbadminuserpw db_administrator_password
--iwstsname tablespace_data --iwslogtsname tablespace_log --iwsplantsname tablespace_plan 
--auth_type SQLSERVER
    where:
    --componenttype
    The HCL Workload Automation component for which the database is upgraded. When upgrading a dynamic domain manager, specify DDM.
    --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 user that has been granted access to the HCL Workload Automation tables on the database server.
    --dbpassword db_password
    The password for the user that has been granted access to the HCL Workload Automation tables on the 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 tablespace_data
    The name of the tablespace for HCL Workload Automation data. The default value for all supported RDBMS is TWS_DATA, with the exception of Oracle where the default is USERS.
    --iwslogtsname tablespace_log
    The name of the tablespace for the HCL Workload Automation log. The default value for all supported RDBMS is TWS_LOG, with the exception of Oracle where the default is USERS.
    --iwsplantsname db_port
    The name of the tablespace for the HCL Workload Automation plan. The default value for all supported RDBMS is TWS_PLAN, with the exception of Oracle where the default is USERS.
    --auth_type db_name
    The MSSQL authentication mode. The default is SQLSERVER which uses native SQL authentication.
    Note: The following parameters specified with the configureDb command are also required when you upgrade the dynamic domain manager with the serverinst command and their values must be the same:
    • rdbmstype
    • dbhostname
    • dbport
    • dbname
    • dbuser
    • dbpassword

Results

You have now successfully upgraded the database for the dynamic domain manager.

What to do next

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