Next key locks....

Raquel Rodriguez

Next key locks....
Hi!!

UDB on Win-Lin has a concept of 'Weak exclusive' lock
and also 'Next Key' locks (Next Key Share, Next Key
Exclusive, Next Key Weak Exclusive).
Coming from DB2 for OS/390 background, I cannot
understand and appreciate what purpose (their
mechanism and their role in promoting data
integrity/concurrency) these Next key locks server.

Would appreciate if someone could explain it to me.

TIA
Raquel.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com



James Campbell

Re: Next key locks....
(in response to Raquel Rodriguez)
Did you read the Admin Guide section on "Lock Attributes" (or "Attributes
of Locks" - depending on the version) which discusses when they are applied
(or only the Certification Guide - which is rather weak on when they are
used)? eg http://www-3.ibm.com/cgi-
bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?
fn=db2v7d0c5lock.htm#HDRATTLCK

James Campbell

On Sat, 28 Dec 2002 21:18:06 -0800, Raquel Rodriguez
<[login to unmask email]> wrote:

>Hi!!
>
> UDB on Win-Lin has a concept of 'Weak exclusive' lock
>and also 'Next Key' locks (Next Key Share, Next Key
>Exclusive, Next Key Weak Exclusive).
>Coming from DB2 for OS/390 background, I cannot
>understand and appreciate what purpose (their
>mechanism and their role in promoting data
>integrity/concurrency) these Next key locks server.
>
> Would appreciate if someone could explain it to me.
>
>TIA
>Raquel.
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
>http://mailplus.yahoo.com
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can