CA WA DE: How to change DB port?

Document ID : KB000113652
Last Modified Date : 12/09/2018
Show Technical Document Details
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.
Question:
How to change the DB port on DE side?
Environment:
CA Workload Automation DE 11.3.x / R12.x
Database : Any
Answer:
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.
[user1@mybox 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.