select ai.appl_name as "Hold App", -- 锁持有者ai.primary_auth_id as Holder,lw.appl_name as "Wait App", -- 锁等待者lw.authid as waiter,lw.lock_mode,lw.lock_ob...
please reference :[url=http://www.ibm.com/developerwork ... 7fechner/index.html]http://www.ibm.com/developerwork ... 7fechner/index.html[/url]分析 DB2 for Linux, UNIX, and Windows 中的锁等待情形