How to change the Database Connection Properties for DE
Article ID: 143702
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==
# 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==
Feedback
Yes
No
Powered by
