Question

1
Replies
325
Views
FredG487 Member since 2009 34 posts
Highmark Health
Posted: 1 year ago
Last activity: 1 year 8 months ago
Closed

SPPR_DEFRAGMENT_TABLE - insufficient privileges to run the procedure

Hello!

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?

Thanks!

Fred.

***Edited by Moderator Marissa to update platform capability tags****

System Administration
Moderation Team has archived post
Share this page LinkedIn