Release Note

Ability to periodically defragment the PR_SYS_LOCKS table

Lock management in Pega 7 is controlled through the database table PR_SYS_LOCKS. Because of the high volume of entries inserted into and deleted from this table during case processing, the data in the PR_SYS_LOCKS table can become highly fragmented, causing degraded performance over time.

You can now periodically defragment this table. The following Dynamic System Settings control when and how often defragmentation takes place using DefragSysLocksDaemon:

  • syslocks/defragIntervalType

    • ​Custom interval type to run defragmentation

    • Set this first – determines whether defragmentation occurs daily at a specified hour or at a recurring interval

  • syslocks/defragHourOfDay
    • ​​Used to run defragmentation at a specified hour
    • Accepts only integer values in the range 0-23
    • Example: run defragmentation daily at 1 AM by entering a value of "1"
    • Can be ignored if syslocks/defragIntervalType indicates a a specified periodic interval

  • syslocks/defragIntervalInHours
    • Used to run defragmentation at specified periodic intervals
    • Accepts only integer values > 0
    • Example: run defragmentation every four hours by entering a value of "4"

    • Can be ignored if syslocks/defragIntervalType indicates a specified hour

For more information, see PEGA0056 alert monitors PR_SYS_LOCKS defragmentation performance.