PDA

View Full Version : Detailed Information on Locking Schemes?

SegFahlt
01-14-02, 17:43
Anybody Know where I can get Down and Dirty(low level) detailed information on how Sybase implements its locking schemes, for 11.9.2?

I looked at the Performance and Tuning guide but found that it didn't contain the detailed information I was looking for.

Any help is appreciated,

TIA,

Bill
MattR
01-14-02, 18:02
Sybase has several whitepapers (I would assume) on how it works. As an FYI, there are three schemes starting from 11.9.2 and up:
APL, DPL, DRL;
All Pages Lock(ed): both the data pages in the table and the index pages (if you have indexes) are locked on modification
DPL: Data-Page Locking (I think that's the acronym). Data pages are locked.
DRL: Data-Row locking; Data rows are locked.
MattR
01-14-02, 18:09
I just found this online. It's from an 11.9.2 presentation but the locking still applies to the 12.X platform.

http://www.sybase.se/download/tk990121pres/sld016.htm