reset password
Author Message
cherylmj01
Posts: 13
Posted 19:02 Jun 04, 2016 |

Considering a transaction which is 2PL but not serial : Would this example be correct?

sl1(x), r1(x), sl2(y), r2(y), xl2(y), w2(y), xl1(x), w1(x), ul1(x), ul2(y)

The main thing i want to be clear about is that can we use exclusive lock without unlocking the shared lock ? 

ngosrani
Posts: 31
Posted 19:05 Jun 04, 2016 |

yes, we can use exclusive lock without unlocking the shared lock and that will be known as lock upgrade.

cherylmj01
Posts: 13
Posted 19:11 Jun 04, 2016 |

Thanks :)