How to change the database hostname/IP. in dSereis (DE)?

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

This article describes the procedure to configure DSERIES to accommodate the change done in DB server.

Environment

Workload automation DE 12.x

Resolution

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

How to change the CA Workload Automation DE (DE) database connection properties?

Validate if the Server Can Connect to the Database