Re: Who is blocking ?

Rainer Schaub wrote: > > I can tell you the solution for OnLine. > Make a onstat -u and onstat -k. > The one who has a L , at onstat -u at the first position on > flags, is blocked. > You have to take the "wait"-adress of this process and have too look > at onstat -k at address. the owner-adress from this row holds the lock. > again look at onstat -u at address. Now you know who helds the lock. > You too can check this via sql at the sysmaster DB. This will get you the session id. To get the pid use onstat -g ses or onstat -g ses <sessid> where sessid is the one found via Rainer's method. Art S. Kagel