This article describes the procedure to configure DSERIES to accommodate the change done in DB server.
Workload Automation DE 11.3.x
Workload automation DE 12.x
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).