Question

42
Views
SuryaMokka Member since 2018 16 posts
Apple Inc
Posted: 3 months ago
Last activity: 3 months ago

SPPR_DEFRAGMENT_TABLE - insufficient privileges to run procedure

Hi,

I have a Pega8.1 system and in the log files, I notice that the SPPR_DEFRAGMENT_TABLE tries to run but can't because there are insufficient privileges. I'm told that the database ID can't have permissions to create and drop tables which are required for this procedure.

I see in the DSS that I can disable the defrag by setting "syslocks/defragEnabled" to false.

What is the negative consequence by not running the defrag? What tables need to be defragmented and how often? What are the Best Practices on table defragmentation?

***Edited by Moderator: Pallavi to change content type from Discussion to Question***  

Pega Platform Case Management Technology Services Lead System Architect
Share this page LinkedIn