+ Reply to Thread
Results 1 to 2 of 2

mainframe (7.1.1) lock escalation

  1. mainframe (7.1.1) lock escalation

    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

  2. Re: mainframe (7.1.1) lock escalation

    "MeBuggyYouJane" wrote in message
    news:bbydnWpY5ai8FjbbnZ2dnUVZ_hudnZ2d@rcn.net...
    > 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


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



+ Reply to Thread