Surya Mokka (SuryaMokka)
Apple Inc

Apple Inc
SuryaMokka Member since 2018 16 posts
Apple Inc
Posted: June 12, 2020
Last activity: November 17, 2020
Posted: 12 Jun 2020 18:23 EDT
Last activity: 17 Nov 2020 7:31 EST

SPPR_DEFRAGMENT_TABLE - insufficient privileges to run procedure


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