How to change the CA Workload Automation DE (DE) database connection properties?

Products

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

Issue/Introduction

Question:

                How to change the CA Workload Automation DE (DE) database connection properties?

 

Answer: 

DE stores database connection information in db.properties file located under <install_directory>/conf directory.  To modify any of the connection properties use the supplied setdbparm.[bat/sh] utility located under <install_directory>/bin.  The changes will be reflected in the db.properties file.

          Supported parameters are:

        database.maxconnections.in.pool

                (max connections in pool)

        javax.net.ssl.trustStorePassword

                (trustStore password)

        database.minconnection

                (minimum connections)

        rdbms.password

                (JDBC Password)

        rdbms.type

                (database type)

        database.connection.monitor.interval

                (db connection monitor interval)

        integratedSecurity

                (Windows native authentication)

        jdbc.Driver

                (JDBC driver)

        database.connection.idle.flush.threshold

                (idle flush threshold)

        javax.net.ssl.trustStore

                (trustStore path including filename)

        database.thresholdconnection

                (threshold connection)

        database.batchupdatelimit

                (batch update limit)

        database.timeout

                (db timeout)

        relational.database.retry.interval

                (db retry interval)

        rdbms.userid

                (db userid)

        database.connection.held.warning.threshold

                (held warning threshold)

        relational.database.retry.attempts

                (db retry attempts)

        jdbc.URL

                (JDBC url)

Note: DE server needs to be restarted for the changes to take effect.

 

Environment

Release: DSWAHA01300-12-Workload Automation DE-High Availability
Component: