Re: Who is blocking ?

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. Rainer Dirk Niemeier wrote: > > Hello again, > I'll place my question again, because I got no answer. > > I have a problem to find out the name of the other user who has locked > the row I have to update. I am locking for a solution for SE and Online > environment with ESQL-C. Perhaps it is very simple. > > Best regards > Dirk Niemeier