I have count the growth of datafile in PEGA database every month, the database size growth faster everday so the disk space runs out quickly. So i want to ask you for this problem, and I want to housekeeping the datafile.
Which table can i housekeeping ? please see the excel file.
And maybe i can do it periodically for maintenance.
***Edited by Moderator Marissa to update SR Details***
Instead of housekeeping the data file at database table level.
The purge/archive strategy approach will provide the archive zip files and maintains the complete state of the case transaction. Later, you can import on a separate archive database. This approach will give the advantage of configuring the reporting database option in the database table instance of the class group.
For example, the activity Rule-Obj-Report-Definition.pxRetrieveReportData have an option to query on AlternateDB.