GeekInterview.com
Series: Subject: Topic:
Question: 9 of 207

Locked Space

What is meant by locked space? Describe locking concepts?
Asked by: sha.vin1987 | Member Since Jul-2010 | Asked on: Jul 5th, 2010

View all questions by sha.vin1987

Showing Answers 1 - 1 of 1 Answers
vjjammi

Answered On : Aug 25th, 2010

View all answers by vjjammi

DB2 Supports Locking mechanism at three levels.

1. Space Level.
2. Table Level.
3. Page Level.

The above hierarchy has some significance and in order to lock a page at the higher level, you needn't lock any other elements at the lower level. But if you wanna lock at the lower level, you should have locks at the related higher level also.
Example : In order to lock a page, you have to lock the table space also.

Locks enable two things.

1. Reading of Data
2. Updating of Data

Types of TableSpace and table Locks.

------------------------------------------------------------------
S.No  Type                    Access                    Access
                                   Required              For others
----------------------------------------------------------------
1.     Share                   Read Only              Read Only
2.     Update                Read with an          Read Only 
                                    intent to update
3.     Exclusive               Update                  No Access
4.     INTENT Share        Read Only             Update      
5.     INTENT Exclusive   Update                  Update
6.     Share Intent Excl.  Read or update     Read only

Types of Page Locks

------------------------------------------------------------------
S.No  Type                    Access                    Access
                                   Required              For others
----------------------------------------------------------------
1.     Share                   Read Only              Read Only
2.     Update                Read with an          Read Only 
                                    intent to update
3.    Exclusive               Update                   No Access


 

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.