Skip to main content

PEGA0056 alert: Defragmentation of the table associated with class System-Locks exceeded the configured time threshold

Suggest edit Updated on October 13, 2021

A PEGA0056 alert occurs when the defragmentation of the table associated with the System-Locks class exceeds the configured time threshold. The alert helps you to monitor the performance of the defragmentation. Because the System-Locks class contains information about locks, an increase in the defragmentation time results in an increase in the time taken by a requestor to acquire a lock.

Example message text

The alert log message indicates that the defragmentation of the table associated with the System-Locks class exceeded the configured time threshold in milliseconds, as shown in the following example:

Defragmentation of Sys Locks table took more than alert threshold of 5000 ms: 5500 ms

Default prconfig.xml setting

The operation time threshold is established in the following prconfig.xml file setting:

<env name="alerts/database/syslockstimethreshold" value="5000" />

Reason for the alert

The defragmentation of the table associated with the System-Locks class exceeds the configured time threshold.

Next steps

You can do the following actions:

  • Modify the defragmentation interval by updating the applicable Dynamic System Settings instance:
    • syslocks/defragIntervalType – Change the value to "HOURLY" or "DAILY", based on your requirement.
    • syslocks/defragIntervalInHours – Increase the value, if the value of syslocks/defragIntervalType is "HOURLY".
    • syslocks/defragHourOfDay – If the value of syslocks/defragIntervalType is "HOURLY", change the hour of execution to allow defragmentation when minimum load is on the server.
  • Disable defragmentation of the table associated with the System-Locks class by setting the syslocks/defragEnabled Dynamic System Settings instance to "false".
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us