Salesforce

Deadlock Prevention (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Deadlock Prevention (Magic xpa 4.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

Station B

Locks table x

Locks table y

Tries to read y

Tries to read x


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

Reference
Attachment 
Attachment