You can schedule or manually trigger the propTablesCleanupTrigger script
to clean up audit and property values tables (alf_audit_ and
alf_prop_ tables).
propTablesCleanupTrigger is a MonitoredCronTrigger script, and a schedule to run this script can be set in the SkyVault-global.properties file or by using JMX. This script does not run by default.
To run this script on a schedule, add the following line to the
SkyVault-global.properties
file:
attributes.propcleaner.cronExpression=* * * * * ? 2099
The value for the property is a Quartz Cron expression and needs to be set to whenever you want the job to run.
Here is an example of the output you should expect to see in the debug
information:
2014-07-24 13:22:17,493 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-3] Processing from 0 to 10000 rows of 2 rows from table alf_audit_app. 2014-07-24 13:22:17,493 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-3] Processing from 0 to 1 rows of 0 rows from table alf_audit_entry. 2014-07-24 13:22:17,509 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-3] Processing from 0 to 10000 rows of 1 rows from table alf_prop_unique_ctx. 2014-07-24 13:22:17,524 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-3] Processing from 0 to 10000 rows of 3 rows from table alf_prop_root.The default batch size is 10000 rows.
CAUTION:
The propTablesCleanupTrigger script is designed for
occasional, scheduled cleanups of the database tables. Ensure that you run this script
during periods when there is minimal or no load on the server. If there is load on the
server while propTablesCleanupTrigger script is running, you might
experience database conflicts and related errors.