In WCC under configuration, we have enabled Reporting Preferences,
Database Cleanup.
But the purge does not seem to work correctly.
The problem is related to Derby resources.
The solution is to tune Derby memory by using the following steps:
1. cd /opt/CA/WorkloadCC/derby/conf
2. cp -p wrapper.conf wrapper.conf.orig
3. vi wrapper.conf and set wrapper.java.maxmemory=2048
4. unisrvcntr restart CA-wcc-db
The purge is now being done successfully after applying this solution.