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.
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/defragHourOfDay– If the value of
syslocks/defragIntervalTypeis "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/defragEnabledDynamic System Settings instance to "false".