Limit Oracle DB connections in WCC

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

Is there a mechanism to limit the number of database connections that WCC creates?  Currently it appears that it opens 40 database connections even when idle.

Environment

CA Workload Control Center 11.3.6, 11.4

Resolution

On Unix, in $CA_WCC_INSTALL_LOCATION/data/config/application/config/resource/connection.properties, find the following parameters and make appropriate adjustment: 

wcc.database.initialSize=10 

wcc.database.maxActive=50 

reporting.database.initialSize=10 

reporting.database.maxActive=50 

Save the change and restart WCC services.

On Windows, the connection.properties file can be located under %CA_WCC_INSTALL_LOCATION%\data\config\application\config\resource.

 

 

Additional Information

The *.database.initialSize parameters set the number of database connections that WCC can create when starting up.  The *.database.maxActive parameters set the maximum number of database connections that the WCC server can establish at any time.