HCL Workload Automation, Version 9.4

Change the DB2 host name, port, or database name

About this task

If you need to change the DB2® host name, port, or database name, use the changeDataSourceProperties utility to reflect these changes in the application server on the master domain manager.

When you installed HCL Workload Automation, the default database name that was used for the creation of the database was TWS (which you might have changed). You also supplied the port and the host name of the DB2 server. If you want to change any of these details, you must do the following:

Stop DB2 and HCL Workload Automation
Use the facilities of DB2 (see DB2 documentation for details) or the operating system to change the database name, port or host name.
Change the configuration of the HCL Workload Automation application server so that it points correctly to the changed DB2 configuration.
The procedure requires you to stop the application server, create a text file of the current data source properties, edit the file, run the utility and restart the application server. Find information about how to do this as follows:
- Application server - using the utilities that change the properties gives a generic description of the procedure for making any change to the WebSphere Application Server properties
- Changing data source properties lists all the data source properties and gives other reference information about the utility
- When editing the text file of the current data source properties:
  1. Edit the text file and locate the following properties:
```
################################################################
# DB2 Type4 Resource Properties
################################################################
DB2Type4DatabaseName=TWS
DB2Type4ServerName=localhost
DB2Type4PortNumber=50083
```
  2. Set the following entries:
    DB2Type4DatabaseName
    
    The new name of the HCL Workload Automation database.
    
    DB2Type4ServerName
    
    The new DB2 server host name.
    
    DB2Type4PortNumber
    
    The new DB2 server port.
    When you change a DB2 server port, you must also modify the configuration of the node where the HCL Workload Automation was cataloged:
    If you are working with a DB2 client, open a command line session and log in as DB2 Administrator, then run the following commands:
    DB2 CLIENT db2 uncatalog node <TWSDBNAME>_ND db2 catalog tcpip node <TWSDBNAME>_ND remote <HOSTNAME> server <NEWPORT>
    
    If you are working with a DB2 server, open a command line session and log in as DB2 Administrator, then run the following commands :
    DB2 SERVER db2 uncatalog node LBNODE db2 catalog tcpip node LBNODE remote 127.0.0.1 server <NEWPORT>
    Do not change any other properties.
  Note: The utility might display a message from the application server (WASX7357I:). You can ignore this message.
Start DB2 and HCL Workload Automation.

This script can also be used to change other data source properties. However, if you do so, HCL Workload Automation might not work correctly. You are advised to make any other changes only under the instructions of HCL Software Support, to correct specific problems. One of those specific problems could be the need to resolve problems with the JBDC driver, see Resolving problems with the JDBC driver.