Locking Heirarcy and Compatibility?

[Chandra Shekar G R]

Can somebody explain the locking heirarchy & compatibility amont various locking mechanism.

Take an example where you have a table in a tablespace with EXCLUSIVE and you have multiple programs accessing the same table with different Isolation level.

Not sure if the above example helps you but I will be happy if you take your own example and explain.

[Veera]

Its answered in your other post, better to maintain single thread for the same topic.

[url]

http://www.ibmmainframeguru.com/Mainfra ... php?t=2425



Thanks,
Veera.