下面的这个语句是导致锁升级的语句,MERGE INTO jg_account AS a USING (SELECT base_e,award_e,account_e,account_id FROM session.account_group) AS b ON a.acct_id = b.account_id ...(more)
环境:AIX 5L操作系统DB2 V8数据库在做快照(db2 get snapshot for all on BGJ1 > all_snap.out)时,发现了Deadlocks里的东西是这样的,是太多了吗?还是怎么?grep -n "Deadlocks" all_snap.out|grep -v "= 0"|more32:Deadlocks detected &nb...(more)