mainframe (7.1.1) lock escalation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MeBuggyYouJane - 28 Jul 2007 19:29 GMT

didn't find a thread here, and a search of the Redbooks came up with
166; a bit too much to download.

Q: if default isolation is Row, does DB2 escalate through Page before
going to Tablespace?

thsnks

Reply to this Message

Mark A - 28 Jul 2007 23:08 GMT

> didn't find a thread here, and a search of the Redbooks came up with 166;
> a bit too much to download.
[quoted text clipped - 3 lines]
>
> thsnks

When row locking is defined and then escalation occurs it goes to
tablespace, not page.

Reply to this Message