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.
但是由于查询并没有导致出现问题的独占锁，您仍然不知道是哪条语句导致了锁定。
They do not prevent different transactions from taking gap locks on the same gap. Thus, a gap X-lock has the same effect as a gap S-lock.
他们并不会阻止不同的事务在相同的间隙获取锁，因此间隙读锁和间隙写锁有相同的影响。
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将阻塞在行锁上。
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)锁，以便将它添加到目标单元。
This is because the new X row lock and the is table lock are not compatible.
这是因为新的x行锁定和is表锁定是不兼容的。
The X lock remains for the duration of the transaction.
在事务期间，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，独占的）行锁。
Additionally, column Mode indicates that it is an X lock that is held by transaction 2.
此外，列Mode表明，事务2持有的是一个x锁。
Now let's start session 2 and have it update another row in the Orders table. Same situation – session acquires and holds X lock on the row with (ID = 2).
现在，我们开启会话2也更新订单表，不同的是更新的数据行为Id=2，同样的在数据行Id=2上也会申请排它锁至到更新事务的结束。
And hit X which will lock it into professional move mode make sure that everything that you do is locked to that movement.
然后点击x，这样会锁定到专业移动模式，你所做的任何操作都会锁定到这种移动模式。
An object's intrinsic lock and its intrinsic condition queue are related: in order to call any of the condition queue methods on object X, you must hold the lock on X .
一个对象的固有锁和它的固有条件队列是相关的，为了调用对象X内条件队列的方法，你必须获得对象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。
应用推荐