Time interval to determine deadlock situations
Message type: E = Error
Message class: DB6 - DB6: Alert Monitoring and Alert Configuration
Message number: 542
Message text: Time interval to determine deadlock situations
What causes this issue?
A Deadlock is a mutual lock of two or more running transactions. It
means that they are both in a wait state and each is waiting for the
other.
Example:
T1 holds lock A and requires lock B.
T2 holds lock B and requires lock A.
The system resolves this wait situation by resetting one of the
transactions after a certain wait time has expired. The parameter
DLCHKTIME determines this wait time.
System Response
The bigger the value set for the parameter, the longer the deadlock
situations continue and block system operation. Conversely, you should
not set too low a value for the parameter, as identifying deadlocks in
the system can affect performance.
How to fix this error?
If errors occur, correct the parameter using the command:
<LB>UPDATE DB CFG USING DLCHKTIME <value></>
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
Error message extract from SAP system. Copyright SAP SE.