Changing the properties for the database

About this task

When you installed HCL Workload Automation, you supplied the database name, the server name, port, the host name of the database server, and other information.

If you need to change any of the database properties such as host name, port, instance owner, or database name, use the datasource_db_vendor.xml template file to reflect these changes in the application server on the master domain manager or on the Dynamic Workload Console.

If you want to change any of these properties, perform the following steps:
  1. Change the configuration of the HCL Workload Automation application server so that it points correctly to the changed database configuration, as follows:
    1. The location of the file to be modified varies depending on whether you have already customized the template or not, as follows:
      If you have no previous customizations defined in the configuration file,
      edit the template located in the templates folder.
      Templates for the master domain manager are stored in the following paths:
      On UNIX operating systems
      TWA_home/usr/servers/engineServer/configDropins/templates
      On Windows operating systems
      TWA_home\usr\servers\engineServer\configDropins\templates
      Templates for the Dynamic Workload Console are stored in the following paths:
      On UNIX operating systems
      DWC_home/usr/servers/dwcServer/configDropins/templates
      On Windows operating systems
      DWC_home\usr\servers\dwcServer\configDropins\templates
      If you have previous customizations defined in the configuration file,
      edit the file located in the overrides folder, which is the file currently used by WebSphere Application Server Liberty.
      The wauser_variables.xml file is located in
      On UNIX operating systems
      TWA_DATA_DIR/usr/servers/engineServer/configDropins/overrides
      On Windows operating systems
      TWA_home\usr\servers\engineServer\configDropins\overrides
      On UNIX operating systems
      DWC_DATA_dir/usr/servers/dwcServer/configDropins/overrides
      On Windows operating systems
      DWC_home\usr\servers\dwcServer\configDropins\overrides
    2. Copy the datasource_db_vendor.xml file to a temporary location.
    3. Modify the following properties in the file based on the values you changed in your database configuration:
      db.serverName
      The name or IP address of the database server
      db.portNumber
      The port number of the database server
      db.databaseName
      The database name
      db.user
      The database instance owner
      db.password
      The database user password. You can optionally encrypt the password, as described in Optional password encryption - secure script.
      db.driver.path
      The path to the JDBC drivers. HCL Workload Automation is supplied using the JDBC driver type 4 for DB2® and type 2 for Oracle. However, each can use the other driver type, if necessary. Software Support might ask you to change to this driver. This procedure must only be performed under the control of Software Support.
      db.sslConnection
      The setting for the SSL connection. true indicates that SSL connection is enabled, false indicates that SSL connection is disabled. .
    4. Browse to the overrides folder:
    5. Create a backup of the datasource_db_vendor.xml.
    6. Replace the datasource_db_vendor.xml file with the file you edited. The changes are effective immediately.
  2. On the master domain manager only, edit the file CLIConfig.properties, in the path TWA_DATA_DIR//broker/config, by updating the value for the property com.ibm.tdwb.dao.rdbms.jdbcPath to reflect the JDBC URL specified. The following is an example of a JDBC value: 
    database_type://hostname:port/dbName
  3. On the master domain manager only , edit the file DAOCommon.properties, in the path TWA_DATA_DIR//broker/config, as follows:
    • In the first line specify the rdbmsName for all DBs.
    • For Oracle only, change all lines and specify the TWS_Oracle_User.
  4. On the master domain manager only, edit the file TWSConfig.properties, in the path TWA_DATA_DIR/usr/servers/engineServer/resources/properties/TWSConfig.properties. If you are using Oracle and MSSQL change the first line. For Oracle only, change all lines. Consider the following example: 
    com.ibm.tws.dao.rdbms.rdbmsName = ORACLE 
 com.ibm.tws.dao.rdbms.modelSchema = <TWS_Oracle_User>
 com.ibm.tws.dao.rdbms.eventRuleSchema = <TWS_Oracle_User>
 com.ibm.tws.dao.rdbms.logSchema = <TWS_Oracle_User>