db2 super exclusive(Z) lock

yinghuabanwo

于 2020-09-15 20:04:54 发布

阅读量311

点赞数

分类专栏： DB2 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/u010663554/article/details/108607756

版权

DB2 专栏收录该内容

16 篇文章

订阅专栏

本文探讨了数据库中超级排他锁(Z)的概念，解释了其如何限制其他应用程序对锁定表格的访问，以及在哪些特定条件下该锁会被获取，如表结构变更时。深入理解锁属性对于优化数据库性能至关重要。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)
A. No other applications can access the table
B. Only uncommitted read (UR) applications can access the table
C. The lock owner and other applications can read, but not update, the locked table
D. The lock owner can both read and update data. Other applications can read the table
E. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Lock attributes:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html

在这里插入图片描述