Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Locks on Views

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

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Mon Oct 12, 2009 7:17 pm    Post subject: Locks on Views
Reply with quote

Hi,
Can you tell me if locks be obtained on locks?


And, If a table is locked, can we say the dependent view is also locked?


-Thanks,
Rakesh
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Oct 12, 2009 7:45 pm    Post subject:
Reply with quote

Rakesh,

Quote:
Can you tell me if locks be obtained on locks?

Why do you want to lock a lock. Sounds Funny.
Can you explain this statement of your's

Quote:
If a table is locked, can we say the dependent view is also locked?

Yes. View is just a reference, it doesn't materialize any data.

Sushanth
Back to top
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Tue Oct 13, 2009 7:48 am    Post subject:
Reply with quote

I am sorry for the confusion.

My first question was:

Can you tell me if locks be obtained on views?
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 Finding locks on z/OS DB2? Ed Goodman DB2 2 Fri Aug 22, 2014 11:55 pm
No new posts Query on system tables to retrieve vi... shankar.v DB2 3 Wed Mar 28, 2012 8:40 pm
No new posts Primery Key / foreign key between Views bauer DB2 1 Fri Dec 16, 2011 11:56 am
No new posts Compare views in Test and Prod MoganaKumaran DB2 1 Fri Sep 10, 2010 12:47 pm
No new posts Views in DB2 l.nethaji Mainframe Interview Questions 1 Wed Jan 06, 2010 9:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us