AWI Analytics Cleanup & Maintenance

Document ID : KB000111667
Last Modified Date : 27/08/2018
Show Technical Document Details
Introduction:
- Would running DB maintenance on the AE database affect the Analytics plug-in on AWI? If data older than a certain number of days is reorged and unloaded on the AE database, can Analytics continue to use data (from the same time period) for trends?

- Is there something similar to the AE DB Utilities to cleanup the Postgres Analytics database?
Instructions:
Since we require Analytics to use its own Postgres database, it stores data independent of the AE database. Running DB reorg / unload and cleaning up old records on the AE side will not affect the data tables on the Analytics side. Analytics will require its own database maintenance and cleanup. There is a dedicated Analytics Action Pack (Package.Analytics_PCK.AUTOMIC_ANALYTICS) which can be downloaded from http://marketplace.automic.com. This action pack contains predefined workflows to perform Postgres database clean-up (check file size / backup) specific to Automic.

General guidelines on Postgres database maintenance can be found here: 
https://docs.automic.com/documentation/webhelp/english/AWA/12.2/DOCU/12.2/AWA%20Guides/help.htm#Analytics/ANOP_Admin/Aaas_datastore_operations_guide.htm