Deadlock Prevention (Magic xpa 2.x)

Magic xpa provides a built-in mechanism for deadlock prevention, which is implemented for the ISAM-type databases that do not feature a deadlock detection or prevention feature. Deadlock situations occur when two users are each waiting for a resource held by the other. For example:

Station A holds table x (in a transaction) and tries to read table y held by station B. Station B is doing the same in reverse order.

Yes, in the Deadlock prevention setting will prevent such deadlocks.

No, in the Deadlock prevention setting will not take any special action to prevent deadlocks.

Using Deadlock prevention (Yes) is recommended for databases that do not have a built-in detection or prevention facilities.

Available values: Yes, No

Default: No

Change effective: Immediate

Magic.ini and Command Line name: DeadlockPrevent