469,602 Members | 1,838 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Locks


Can lock be obtained for index-key?
Jul 3 '06 #1
2 1329

"John Smith" <jo********@microsoft.comwrote in message
news:0b********************@news.siol.net...
>
Can lock be obtained for index-key?
You _can_ lock a table via the LOCK TABLE statement but there is no LOCK
INDEX statement. DB2 will lock as much of an index as it needs to but your
application cannot specifically request a lock on an index.

--
Rhino
Jul 3 '06 #2
John Smith wrote:
Can lock be obtained for index-key?

Depending on isolation level and the actual index used in the query, locks
are acquired by the engine automatically as needed. There is no explicit
locking commands except at the table level.

Art S. Kagel
Jul 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by aswinee | last post: by
17 posts views Thread by Dr NoName | last post: by
6 posts views Thread by John Carroll | last post: by
reply views Thread by Bruce Pullen | last post: by
1 post views Thread by Zri Man | last post: by
4 posts views Thread by Alex Callea | last post: by
7 posts views Thread by praveen | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.