We need to change the database connection information used by DE. What is the best practice and the best procedure for this modification.

Release : 12

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

You can proceed by the following steps in order to modify your database connection properties for DE:



# cd /opt/CA/WorkloadAutomationDE/bin < =====

# ./validateDbConnection.sh < =====


JDBC driver class: oracle.jdbc.driver.OracleDriver
JDBC URL: jdbc:oracle:thin:@//[hostname.domainname]:1521/orcl
Database user id: esp
Encrypted database password: QkdgtcYJbueRXQ4om+ykww==



# ./setdbparm < =====


Supported parameters are:
database.timeout
(db timeout)
javax.net.ssl.trustStore
(trustStore path including filename)
database.connection.idle.flush.threshold
(idle flush threshold)
connection.socket.timeout.threshold
(Connection socket timeout threshold (in minutes))
database.batchupdatelimit
(batch update limit)
javax.net.ssl.trustStorePassword
(trustStore password)
database.thresholdconnection
(threshold connection)
database.minconnection
(minimum connections)
relational.database.retry.attempts
(db retry attempts)
jdbc.Driver
(JDBC driver)
database.connection.held.warning.threshold
(held warning threshold)
jdbc.URL
(JDBC url)
rdbms.type
(database type)
rdbms.password
(JDBC Password)
integratedSecurity
(Windows native authentication)
database.maxconnections.in.pool
(max connections in pool)
relational.database.retry.interval
(db retry interval)
rdbms.userid
(db userid)
database.connection.monitor.interval
(db connection monitor interval)



# cd ../conf < =====

# cat db.properties < =====


######################
# Database
######################
jdbc.Driver=oracle.jdbc.driver.OracleDriver
jdbc.URL=jdbc:oracle:thin:@//[hostname.domainname]:1521/orcl
rdbms.type=Oracle
rdbms.userid=esp
rdbms.password=QkdgtcYJbueRXQ4om+ykww==



# cd ../bin < =====

# ./stopESP < =====


Stopping the default Agent
Agent service is stopping...
Agent service has been stopped
Default Agent stopped gracefully

Stopping the server...
The server has stopped gracefully.



# cd ../conf < =====

# cp db.properties db.properties_backup < =====

# vi db.properties < =====


######################
# Database
######################
jdbc.Driver=oracle.jdbc.driver.OracleDriver
jdbc.URL=jdbc:oracle:thin:@//[hostname.domainname]:1521/orcl < ===== Apply the required modification

rdbms.type=Oracle
rdbms.userid=esp
rdbms.password=QkdgtcYJbueRXQ4om+ykww==



# cd ../bin < =====

# ./startESP < =====

Starting server: [STARTED]
Starting the default Agent
Default Agent Started OK



# ./validateDbConnection.sh < =====


JDBC driver class: oracle.jdbc.driver.OracleDriver
JDBC URL: jdbc:oracle:thin:@//[hostname.domainname]:1521/orcl
Database user id: esp
Encrypted database password: QkdgtcYJbueRXQ4om+ykww==