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
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:
- On the workstation where the dynamic domain manager is installed, extract the HCL Workload Automation installation package to a directory of your choice.
- Browse to the image_location/TWS/interp_name path.
- 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
- --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.