You can schedule or manually trigger the propTablesCleanupTrigger script
to clean up audit and property values tables (alf_audit_ and
alf_prop_ tables).
Note: This script can only be used with SkyVault 2.0 and later.
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, add the following line to the
SkyVault-global.properties
file:
attributes.propcleaner.cronExpression=* * * * * ? 2099Here is an example of the output that 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.