Question
2
Replies
113
Views
ANZ Asia Pacific Division
Posted: November 21, 2017
Last activity: October 12, 2018
Closed
AES 7.1.7 and AES 7.2 health check for purging (clean up) the old AES data
how to check the AES 7.1.7 and AES 7.2 clean up happening or not , Please advise for health check of purging the AES data
***Edited by Moderator Marissa to update categories***
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Be aware that database may still grow even if clean-up / purge is working properly as the DBMS may not reclaim space from deleted rows automatically - especially space from the blob / pzpvstream columns. It may be necessary to engage a DBA to schedule DBMS maintenance jobs to reclaim / reorg / vacum / alter-table-move / etc tables. If your DBMS supports partitioning it is possible to partition specific tables and periodically truncate partitions to force space reclamation.
The following article has lots of useful AES troubleshooting tips:
https://pdn.pega.com/troubleshooting-aes-717-and-aes-72-connectivity-performance-and-reporting-problems/troubleshooting#checklist-avoid-problems
Including the query to run to see if the alert and exception data in the DB is being trimmed or not:
Modify the following pseudo SQL to see if data is being correctly trimmed in the alert and exception table. Modify the pseudo SQL as required by your database management system.