any recommendation for H2 database routine management?
Few days ago I upgraded PMS/PMC server which runs PMS 11.31 from Windows 2012 Std to Windows 2012 R2 Std (among ~1400 nodes we stil have few Windows 2003 servers; hence we can not upgrade yet to ver 12.00).
Regardless of shutting down all the F-Secure related services prior to the upgrade, I was not able to login to PMC when the upgrade was completed; gladly runing fspms-db-recovery tool, fixed this problem.
At that stage I realized that PMC can be again really fast and responsive if it is not clogged with whatever clutter is left behind during the regular operation. Please note that I did not purge any Reports or Alerts.
Server is usually rebooted monthly after installing Windows OS updates, but the PMC performance noticeable gets degrading over time unless the recovery tool, available at ftp://ftp.f-secure.com/support/tools/pm/recovery-tool/, is run against it.
Running recovery tool is not a huge inconvenience but the process is pretty manual
I have not seen any DB cleanup features in the PMS 12.00 release notes, nor was not able to find any recommendation in the documentation or in the community posts regarding routine database maintenance; hence if I may I would like to ask for an enhancement in the future software releases for an internaly run process to clean DB as a task which could be scheduled or even executed autimatically.