How to change the Database Connection Properties for DE

book

Article ID: 143702

calendar_today

Updated On:

Products

CA Workload Automation DE DSERIES- SERVER CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

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

 

 

 
 
 




Environment

Release : 12

Component : CA WORKLOAD AUTOMATION DE (DSERIES)

Resolution

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==