For user and server processes, PMON will release the locks held by users, roll back every uncommitted transaction, and release any resources this process is using.
而对于用户和服务器进程,PMON将释放用户持有的锁,回滚每个未提交事件,并释放该进程正在使用的所有资源。
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 将阻塞在行锁上。
Isolation: the degree of isolation this transaction has from the work of other transactions. For example, can this transaction see uncommitted writes from other transactions?
事务隔离:当前事务和其它事务的隔离的程度。例如,这个事务能否看到其他事务未提交的写数据?
应用推荐