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.
Download free practice test for db2 DB2 Certification exam. Become IBM IBM DB2 9 Family Fundamentals certified.
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.
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.