As I’ve understood, to “Retire” a record doesn’t (permanently) delete the record from the database. The (permanent) “Delete” operation will be executed by the Cleanup Agent. (It seems that the Cleanup Agent is used to clean up the DC jobs. I’m not sure if it is the same agent for deleting the records.) But I can’t find the configuration for the frequency of the Cleanup Agent. Also, can we execute the cleanup operation immediately from the Admin Console? Thanks in advance for your help.
Retiring a record will not mark the record as deleted, and hence, will not be cleaned up by the Cleanup Agent. The record needs to be deleted for the Cleanup Agent to pick it up and (permanently) delete it from the database. The Cleanup Agent, apart from other cleanup, cleans up all the records marked for deletion, which were deleted 24 hours or more. There is no other agent to clean the deleted records. The Cleanup Agent will run only once a day. You can specify the time at which you want to start the Cleanup Agent. The property is called CLEAN_HOUR and is specified in your TRIRIGAWEB.properties. The Cleanup task can be executed from the Admin Console too. If you navigate to Database Manager > Database Admin Task, you will find the different cleanup processes you can perform.
If your goal is to delete the record immediately, there is a way to force the Cleanup Agent to delete records that are only minutes old. You can add the property CLEANUP_AGENT_RECORD_DATA_AGE=2 to your TRIRIGAWEB.properties and restart the server. Once the Cleanup Agent is run from the Admin Console, records that are older than 2 minutes will be permanently deleted. This is especially useful when you perform a data load and need to delete the data to run it a second time.
[Admin: This post is related to the 07.08.15 post about manually running the Cleanup Agent.]