informix table lock

select unique
 dbsname db,
 tabname ,
--zt02,
 case
 when type="S" then "shared lock"
 when type="IS" then "intent shared lock"
 when type="SIX" then "shared intent excl lock"
 when type="XS" then "shared key value by RR"
 when type="IX" then "intent excl lock"
 when type="X" then "exclusive lock"
 when type="XR" then "excl key value by RR"
 when type="U" then "update lock"
 when type="B" then "byte lock"
 else
 "unknown lock type"
 end lock_type,
 lpad(owner,5) ses_id,
 lpad(waiter,5) wait_id
 from sysmaster:syslocks
--  left outer join ds:zt_file on zt01=tabname
 where tabname != 'sysdatabases'

找出 wait_id 有值的.代表他在等某一個東西 release.

nstat -g ses | grep  88999  (note ses_id)
find session id to query processs id  再去KILL 他.