+4Hi All;
On the Health report I see warning link below.
Scale Statistics -> "The CommServe database tables are too large. But this is quite fresh instalation.
In more detailes I see that problem is with table "APP_ReportsHistory" 109 MB
dbmaintenance -full was performed. How we can turn this parameter?
Regards;
Pawel
Best answer by Stuart Painter
Hi Pawel
I have looked up the details on the hotfix and it appears the report history was being updated each time an FR, MR or services restart was performed, which causes the table to bloat. This behaviour is fixed with the hotfix, so the table should no longer increase in size, but existing records will remain until pruning occurs.
These records will be pruned automatically after 90 days, so you should see this table reduce in size after this time.
Thanks,
Stuart
Hi Pawel
Thanks for the question, please would you confirm what Feature Pack and Maintenance Release you are running?
There was an issue identified with this table that has been resolved with Hotfix 2622, included in MR22 for FR20:
https://documentation.commvault.com/commvault/v11/article?p=11_20_36.htm
APP_ReportsHistory table may grow to a large size and show up in the health report - 2622
Please let me know your current version and if MR22 or above is applied?
Thanks,
Stuart
Hi Pawel
I have looked up the details on the hotfix and it appears the report history was being updated each time an FR, MR or services restart was performed, which causes the table to bloat. This behaviour is fixed with the hotfix, so the table should no longer increase in size, but existing records will remain until pruning occurs.
These records will be pruned automatically after 90 days, so you should see this table reduce in size after this time.
Thanks,
Stuart
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
