What is the INTENT NONE lock?

April 16th, 2006 by uCertify Leave a reply »

In the INTENT NONE lock, a lock owner can read all data, including uncommitted data, stored in the locked resource. However, the lock owner cannot modify data stored in the locked resource. This lock does not prevent any other access to the table, be that in the form of selects, inserts, updates, deletes, etc. This lock, however, prevents another application/user from dropping the table while the query is running.

Become IBM DB2 Certification certified. Best exam simulation IBM 000-730 download free trial.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark
Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.