PEGA database house keeping
Hi All,
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.
Brgds,
Dendi A
***Edited by Moderator Marissa to update SR Details***
Posted: 2 years ago
Hi,
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.
Please let me know if I am missing something.
Thanks
Sandeep P V