Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 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***
To see attachments, please log in.
Data Integration
Support Case Exists

Posted: 6 years ago
Posted: 16 May 2018 0:37 EDT
Venkata Sandeep Kumar Pamidamarri (SandeepPamidamarri)
Toyota Financial Services
Venkata Sandeep Kumar Pamidamarri
Toyota Financial Services
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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice