HCL Workload Automation, Version 9.4

Reporting the changed host name or IP address of the workstation where you installed the RDBMS

About this task

If you changed the host name or IP address in the workstation where you installed the RDBMS, contact your database administrator to reconfigure your RDBMS to use the new host name or IP address. If you are using DB2, see the procedure described in https://www-304.ibm.com/support/docview.wss?uid=swg21258834.

Propagate the changes to the following components by performing the steps below:
  • Master domain manager
  • Backup master domain manager
  • Dynamic domain manager
  • Backup dynamic domain manager
  1. Stop the WebSphere Application Server.
  2. Run the showDataSourceProperties tool by redirecting the output to a text file to obtain the current properties.
  3. Open the file and identify the database section where the databasetypeTypenJndiName property is equal to jdbc/twsdb.

    where databasetype is the database you are using, for example DB2, and n can be 2 or 4.

    Below an example of the section you have to refer to if you are using DB2: 
    ################################################################
DB2 Type4 Resource Properties
################################################################
DB2Type4JndiName=jdbc/twsdb
DB2Type4DatabaseName=TWSZ
DB2Type4DriverType=4
DB2Type4ServerName=myhost.mydomain.com
.....
  4. Verify the value of the databasetypeTypenServerName property. If this value is changed proceed with Step 5. If this value is not changed skip the steps below.
  5. Modify the databasetypeTypenServerName=value property by running changeDataSourceProperties. For more information, see Changing the database host name, port, or database name.
  6. To use the:
    Dynamic Workload Console reports
    Update the database connections.
    Command line reports
    Update the following section of the <report_home>\config\common.properties file 
    ######################################################################
# DATABASE PROPERTIES
######################################################################
# Specify the host name or TCP/IP address of the database,
# its port number and name.
DatabaseHostname=<hostname>
DatabasePort=50000
DatabaseName=TWS
........................
    Where <report_home> is the directory where you extract the package.
  7. Restart the WebSphere Application Server.