P LOCK AND V LOCK
What are "Internal Plan Lock" and "Internal Variation Lock" objects ?
Answer
Internal Plan Lock(P lock) (Package Cache/ Plan Lock): Any execution of SQL, whether static or dynamic, must be done while holding a 'package lock'. This ensures that no-one can drop the package that is being executed. This can be turned off with the registry variable DB2_APM_PERFORMANCE=ALL.
Internal Variation Lock(V lock): Any execution of dynamic SQL is done via an entry in the SQL cache known as a variation. In order to ensure that the variation remains valid during the execution, V locks are acquired on behalf of the entry.
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞0Ctrl+Enter 发表
作者其他文章
评论 0 · 赞 0
评论 0 · 赞 0
评论 0 · 赞 1
评论 0 · 赞 0
评论 2 · 赞 2
添加新评论0 条评论