Removing embedded Derby from WCC

Products

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

Issue/Introduction

We initially used Derby for the WCC database but have switched to an external database.

Can we remove the Derby files from WCC without issue?

 

Example:

/opt/CA $ find . -name derby*
./WorkloadCC/tomcat.old/webapps/resources/WEB-INF/lib/derby-10.12.1.1.jar
./WorkloadCC/tomcat.old/webapps/asi/WEB-INF/lib/derbyclient-10.13.1.1.jar
./WorkloadCC/tomcat.old/webapps/collector/WEB-INF/lib/derbyclient-10.12.1.1.jar
./WorkloadCC/tomcat.old/webapps/collector/WEB-INF/lib/derby-10.12.1.1.jar
./WorkloadCC/tomcat.old/lib/derbyclient-10.12.1.1.jar
./WorkloadCC/tomcat_32.old/webapps/reporting-collectors/WEB-INF/classes/com/ca/uejm/datawarehouse/derby.properties
./WorkloadCC/tomcat_32.old/lib/derbyclient-10.12.1.1.jar
./WorkloadCC/bin/lib/derbyclient.jar
./WorkloadCC/bin/lib/derby.jar
./WorkloadCC/tomcat_32/webapps/reporting-collectors/WEB-INF/classes/com/ca/uejm/datawarehouse/derby.properties
./WorkloadCC/tomcat_32/lib/derbyclient-10.12.1.1.jar
./WorkloadCC/tomcat/webapps/resources/WEB-INF/lib/derby-10.12.1.1.jar
./WorkloadCC/tomcat/webapps/asi/WEB-INF/lib/derbyclient-10.13.1.1.jar
./WorkloadCC/tomcat/webapps/collector/WEB-INF/lib/derbyclient-10.12.1.1.jar
./WorkloadCC/tomcat/webapps/collector/WEB-INF/lib/derby-10.12.1.1.jar
./WorkloadCC/tomcat/lib/derbyclient-10.12.1.1.jar

Environment

Release : 11.4

Component : WORKLOAD CONTROL CENTER

Resolution

The derby files cannot be removed, they are present even if derby was not initially selected. Attempting to remove them will result in errors for WCC.