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, 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:

Change the configuration of the HCL Workload Automation application server so that it points correctly to the changed database configuration, as follows:
1. Browse to the following path:
  Dynamic Workload Console
  DWC_DATA_dir/usr/servers/dwcServer/configDropins/templates/datasources
  master domain manager
  TWA_DATA_DIR/usr/servers/engineServer/configDropins/templates/datasources
  Dynamic Workload Console
  DWC_home\usr\servers\dwcServer\configDropins\templates\datasources
  master domain manager
  TWA_home\usr\servers\engineServer\configDropins\templates\datasources
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 user
  
  db.password
  
  The database user password. You can optionally encrypt the password, as described in Encrypting passwords (optional).
  
  db.driver.path
  
  The path to the JDBC drivers. IBM Workload Scheduler 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. IBM Workload Scheduler Software Support might ask you to change to this driver. This procedure must only be performed under the control of IBM Workload Scheduler 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 following path:
  Dynamic Workload Console
  DWC_DATA_dir/usr/servers/dwcServer/configDropins/overrides
  master domain manager
  TWA_DATA_DIR/usr/servers/engineServer/configDropins/overrides
  Dynamic Workload Console
  DWC_home\usr\servers\dwcServer\configDropins\overrides
  master domain manager
  TWA_home\usr\servers\engineServer\configDropins\overrides
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.
7. 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</varname>>://<<varname>hostname>:<port>/<dbName>
```
8. 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.
9. 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, Informix, 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>
```