Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Still fighting to get correct answer - can you advise?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
CIS777
Currently Banned

New User


Joined: 16 Sep 2005
Posts: 6

PostPosted: Sun Sep 25, 2005 9:50 pm    Post subject: Still fighting to get correct answer - can you advise?
Reply with quote

Which of the following statements about lock compatibility are true?

A. USER1 can hold an IS lock on a page at the same time USER2 holds an IX lock on the same page.

B. USER1 can hold a U lock on a page at the same time USER2 holds an S lock on the same page.

C. USER1 can hold an IX lock on a page at the same time USER2 holds a U lock on the same page.

D. USER1 and USER2 can each hold an IX lock on the same page at the same time.

E. USER1 and USER2 can each hold a U lock on the same page at the same time.
Back to top
View user's profile Send private message

ikumar

New User


Joined: 02 Aug 2005
Posts: 81

PostPosted: Mon Sep 26, 2005 1:12 am    Post subject: Re: Still fighting to get correct answer - can you advise?
Reply with quote

Option B is correct, not sure about others
Back to top
View user's profile Send private message
anadhamohan

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Wed Sep 28, 2005 10:40 am    Post subject:
Reply with quote

Options E is correct, any number of users can have U lock on a page, its otherwise said as Read-only lock.
Option B is also correct, when a user is having IS lock then it's shared for other users also, but when the other user make any updations to the row contained in that page then it gets IX lock so no one can able to access that page.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the explanation correct? XRST,CHKP Martylin IMS DB/DC 1 Wed Mar 15, 2017 9:26 am
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm
No new posts print out the correct info in LOOP? jackzhang75 CLIST & REXX 7 Wed Dec 23, 2015 10:39 pm
No new posts Output file not getting populated in ... sandeep kumar302 COBOL Programming 7 Tue Apr 29, 2014 12:24 pm
No new posts Advise on TOD Clock usage in PL/1 or ... thanoozm PL/I & Assembler 11 Wed Jul 25, 2012 2:01 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us