CA WA DE: How to change DB port?

Products

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

Issue/Introduction

The CA WA DE connects to the database.  The database service may use ports that are different from default setup.
The exact port has to be defined in the DE side for proper communication.

How to change the DB port on DE side?

Environment

CA Workload Automation DE 11.3.x / R12.x
Database : Any

Resolution

The CA WA DE uses JDBC to connect to the database.  The db.properties file contains the JDBC url.  
The db.properties is located in <CA_WA_DE_install_directory>/conf.  Edit the JDBC url in the properties to match port number on the database side.

Change the port (in blue) as shown in the following JDBC url examples.  Restart the DE service.
 

Oracle:
jdbc:oracle:thin:@[db.example.com]:1531:dedb

MS-SQL
jdbc:sqlserver://sqlhost:1433;databaseName=AdventureDB;integratedSecurity=true;

PostgreSQL
jdbc:postgresql://dbhost:5432/dedb

DB2
jdbc:db2://dbhost:3306/db

Additionally, use the setdbparm (in <CA_WA_DE_install_directory>/bin) utility to change the JDBC url with the new port.

[[email protected] bin]# ./setdbparm jdbc.URL
Changing JDBC url (jdbc.URL)
Enter new JDBC url: jdbc:postgresql://dehost.example.com:5432/dseries
Verify new JDBC url:jdbc:postgresql://dehost.example.com:5432/dseries
Changed. The Server must be restarted for the change to take effect

Additional Information

Note: If you have High Availability (HA), then both db.properties will need to be updated in both servers.
Always backup files when editing or making changes to them.