Idea Details

CA SAM - Improve History Cleanup

Last activity 11-07-2018 12:13 PM
Francois_Auvray's profile image
01-04-2018 02:18 AM

CA SAM History Cleanup is only available from the Tool Menu. Furthermore, cleanup his transactional (row by row), which means it takes a very long time to perform for big installations (several days...) and needs an extremely large transaction log files for database.

Two improvements would be necessary:

- Allow a complete non transactional cleanup (eg. save "create" actions,  truncate history table and recreate "create" action)

- Allow cleanup to be planned (once, once a day, once a week...) and have it handled by a specific Cron Job


Comments

11-07-2018 12:13 PM

Improvements for history tables was delivered in the 4.1.5 release.

 

In order to reclaim hard disk space, it is now possible to trim history  tables based on a user-provided date. This will also improve the  performance of history views.