Question

1
Replies
65
Views
 Dendi Abdurahman (DendiA71)
PT Bank Sinarmas

PT Bank Sinarmas
ID
DendiA71 Member since 2016 10 posts
PT Bank Sinarmas
Posted: May 15, 2018
Last activity: May 29, 2018
Posted: 15 May 2018 22:44 EDT
Last activity: 29 May 2018 16:17 EDT
Closed

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***
Data Integration Support Case Exists
Moderation Team has archived post, 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
Posted: 16 May 2018 0:37 EDT
Venkata Sandeep Kumar Pamidamarri (SandeepKumarP_Incess)
Incessant Technologies
Senior Technical Lead
Incessant Technologies
AU

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