因为获得的锁不会跨事务边界存在,所以import工具将失去它的IX表锁,并且必须在每次提交之后请求另一个锁。
Because the acquired lock does not persist across transaction boundaries, the import utility loses its IX table lock and must request another lock after each commit.
DB2在执行索引或表扫描时,如果遇到一个被另一个事务独占 (X)锁定的未提交行,那么 DB2 将阻塞在行锁上。
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.
在事务开始时,在表级别创建数据快照,只能识别其他事务已提交的数据更新。
The transaction can only recognize data modifications that were committed before the start of the transaction.
在事务开始时,在表级别创建数据快照,只能识别其他事务已提交的数据更新。
The transaction can only recognize data modifications that were committed before the start of the transaction.
应用推荐