LinkedIn
Copied!

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

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".

Have a question? Get answers now.

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