What is my lock request waiting for?
我的锁请求在等待什么?
Start a child thread that evaluates the lock request.
启动一个对锁请求进行处理的子线程。
The output indicates that you are waiting on the lock on the row (0;A) from the db2pd output because the 'Sts' column, which provides the status of the lock request, shows a W for waiting.
输出表明等待的是db2pd 输出中的行(0;A)上的锁,因为提供锁请求状态的 ‘Sts’列显示W,表示等待。
If multiple arrows show a circular lock-request pattern — threads prevent each other from running because they are waiting for each other to release a lock — then you have a deadlock.
如果多个箭头显示一个环形的锁请求模式—由于它们正在相互等候其它线程释放锁,所以线程彼此阻止运行—结果就形成了一个死锁。
To avoid situtations like this, DB2 V8.2 supports the so called lock-request-clause.
为了避免这样情况发生,DB2V8.2支持所谓的 lock-request-clause。
To avoid situtations like this, DB2 V8.2 supports the so called lock-request-clause.
为了避免这样情况发生,DB2V8.2支持所谓的 lock-request-clause。
应用推荐