Re: how to know who has locked particular table ?

Garnadi wrote: > > I'd like to know who has locked particular table. > What should I do ? Find the table's (or its fragments') partnum(s) and compare to the output of onstat -k the owner column gives you the sessions shared memory address which you can look up in the onstat -u output to get the session id which you can use in onstat -g ses <sessid> to see the user, pid, tty, client host, query, etc. There have also been posts of SMI queries to accomplish this but I'm a brute force kind of guy. If you are looking because you need exclusive access to the table for and index build, etc., you will also have to look for row/page locks and index node locks as well as table level locks. Art S. Kagel