topic Lock Modes in Application Development and Automation Discussions

Lock Modes

Former Member — Sun, 20 Apr 2008 20:16:20 GMT

Could anyone in detail explain me what is extensible or enhanced lock and exclusive lock and then what do u mean by sayin exclusive lock does not allow accumulation?

Re: Lock Modes

Former Member — Sun, 20 Apr 2008 20:25:20 GMT

Hi,

Please refer the link below:

http://help.sap.com/saphelp_nw04/helpdata/en/c2/2d7037ecc92a7ee10000009b38f8cf/frameset.htm

Thanks,

Sriram Ponna.

Re: Lock Modes

Former Member — Mon, 21 Apr 2008 11:29:56 GMT

hi,

There are 3 types of lock modes .

Lock objects are use in SAP to avoid the inconsistancy at the time of data is being insert/change into database.

- Read Lock(Shared Locked) protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the table

- Write Lock(exclusive lock)

protects write access to an object. The write lock allows other transactions neither read nor write access to

the locked area of the table.

- Enhanced write lock (exclusive lock without cumulating)

works like a write lock except that the enhanced write lock also protects from further accesses from the same transaction.

Re: Lock Modes

Former Member — Mon, 21 Apr 2008 11:40:11 GMT

Lock mode E (extensible): This sets a lock for changing data for single user. This lock can be accumulated.

Lock mode X(exclusive): This mode is used like mode E for changing data. The only technical difference from mode E is that the respective lock does not allow accumulation.

Lock mode S(SHARED): This mode ensures that data displayed in your program cannot be changed by other users during the entire display time. Here you do not want to change the data yourself (allows read only access for data).