The hang is caused by an exclusive row lock on table EMPLOYEE.
挂起是由表 EMPLOYEE上一个独占式的行锁导致的。
That lock is the row lock that is associated with the row being exported.
该锁是与正在被导出的行相关联的行锁。
Each row in the chart refers to a different lock.
图表中的每一行指的是一个不同的锁。
Why does DB2 lock this table, row, or object?
为什么DB 2锁住了这个表、行或者对象？
Transaction 1 reads a specific record and places a lock on that row.
事务1读取某条特定记录并对该行应用一个锁。
These locks could be table level, row level, or lock on index, and so on.
这些锁可以是表级锁、行级锁、索引锁等等。
Agent 2: NS lock WAITING on main table row ID (0; a) (from select).
代理2：ns锁对于主表行(0；a)为WAITING(由于select)。
Agent 2: NS lock GRANTED on child table row ID (0.4) (from select).
代理2：ns锁对子表行ID(0.4)为GRANTED(由于select)。
Agent 2: NS lock GRANTED on child table row ID (0.4) (from select).
代理2：ns锁对子表行ID(0.4)为GRANTED(由于select)。
应用推荐