I need to change the Database server hostname/IP. How to configure DSERIES for this change?

Document ID : KB000112748
Last Modified Date : 18/09/2018
Show Technical Document Details
Introduction:
This article describes the procedure to configure DSERIES to accommodate the change done in DB server.
Environment:
Workload Automation DE 11.3.x
Workload automation DE 12.x
Instructions:
1- Stop DE server (If running in High Availability (HA) mode, stop standby server first) before the hostname is changed at DB server.

2- In DE primary server, execute the "setdbparm" utility  to change the "jdbc.URL"  parameter, and enter the new DB URL connection, containing the new db server hostname/ip address.

Change to the following directory at the command prompt:

On Windows:  install_dir\bin

On UNIX: install_dir/bin

Enter the following command:

On Windows: setdbparm.bat jdbc.URL

On UNIX: ./setdbparm.sh jdbc.URL

 

PS: The setdbparm utility will change the contents of <install_directory>/conf/db.properties file. Please take a backup before doing it.

3- Test the DB connection using the "validateDbConnection.bat" (Windows) or "validateDbConnection.sh" (Unix) script located in /bin folder.

4- (HA only) Copy the db.properties file to standby server. After that, execute the same test mentioned in step3.

5- Start DE servers (If running in HA mode, start primary server first).

Additional Information:
https://comm.support.ca.com/kb/how-to-change-the-ca-workload-automation-de-de-database-connection-properties/kb000042062

https://docops.ca.com/ca-workload-automation-de/12-0/en/installing/installing-ca-workload-automation-de/verifying-a-single-server-installation#VerifyingaSingleServerInstallation-ValidateiftheServerCanConnecttotheDatabase