As all rows in the EMPLOYEE table are X-locked by the first transaction, the second application goes into lock wait mode.
由于employee表中的所有行都被第一个事务独占锁定,第二个应用程序进入了锁等待模式。
But as the query did not cause the problematic X-lock, you would still not know which statement was responsible for the lock.
但是由于查询并没有导致出现问题的独占锁,您仍然不知道是哪条语句导致了锁定。
The X lock remains for the duration of the transaction.
在事务期间,x锁一直保持。
The job is suspended, because JobOne is holding an X lock on page b.
因为JobOne持有页b的x锁,所以作业被挂起。
Additionally, column Mode indicates that it is an X lock that is held by transaction 2.
此外,列Mode表明,事务2持有的是一个x锁。
The import utility accomplishes this by requesting an exclusive (X) lock on the table at the beginning of an ALLOW NO ACCESS import operation.
import工具实现这一点的方法是在ALLOWNOACCESS导入操作的开始请求目标表上的一个排他(X)锁。
The row is formatted in the target page and an X (exclusive) row lock is obtained on it.
在目标页中对该行进行格式化,并获得该行上的一个X(exclusive,独占的)行锁。
When DB2 performs an index or table scan, DB2 will block on a row lock when it comes across an uncommitted row which another transaction has exclusively (X) locked.
DB2在执行索引或表扫描时,如果遇到一个被另一个事务独占 (X) 锁定的未提交行,那么 DB2将阻塞在行锁上。
Takes an exclusive (x) lock on the block.
获得块上的一个独占(X)锁。
In fact, when this feature is enabled, and the INSERT operation requires a new or reused block, DB2 will take an exclusive (x) lock on the block in order to add it to the target cell.
实际上,当该特性被启用,并且INSERT操作要求一个新的或重用的块时,DB 2将在块上采用一个独占的(X)锁,以便将它添加到目标单元。
LIU X. Analysis and experiment study on stress of structure based on lock-in thermography [d]. Harbin: Harbin Institute of Technology, 2012.
[3]刘勋。基于红外锁相热像的复合结构件应力分析及其实验研究[D]。哈尔滨:哈尔滨工业大学,2012。
LIU X. Analysis and experiment study on stress of structure based on lock-in thermography [d]. Harbin: Harbin Institute of Technology, 2012.
[3]刘勋。基于红外锁相热像的复合结构件应力分析及其实验研究[D]。哈尔滨:哈尔滨工业大学,2012。
应用推荐