Locking Heirarcy and Compatibility?

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Chandra Shekar G R
Posts: 14
Joined: Fri Apr 06, 2007 11:22 pm

Locking Heirarcy and Compatibility?

Post by Chandra Shekar G R » Fri Apr 20, 2007 9:41 am

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.

Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Fri Apr 20, 2007 10:03 pm

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


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


Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others