How to check what process is blocking another proc

Hi All, Anyone who knows on How to check what processid is blocking another process? I did check using: onstat -g ses xxxxx, where xxxxx is the session id. onstat -g sql xxxxx onstat -u|grep xxxxx I've seen some processes with status "L--BP---" and L--P, these are the process that being blocked.I also noticed that xxxxx process has no "SQL statement status except "-". All i want to do is to identify what process makes the other processes blocked. If it's a select from sysmaster table, that would be fine.. if it's onstat, it would be fine too.

onstat -k will show you all locks on tables and data. You can see from those waiting to lock the same resource what's being blocked. Just look for 'x' exclusive locks. There's an equivalent sysmaster query on syslocks, but I'm too groggy to retrieve it this AM. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 8, 2010 at 4:58 AM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > Anyone who knows on How to check what processid is blocking another > process? I > did check using: > > onstat -g ses xxxxx, where xxxxx is the session id. > onstat -g sql xxxxx > onstat -u|grep xxxxx> > I've seen some processes with status "L--BP---" and L--P, these are the > process that being blocked.I also noticed that xxxxx process has no "SQL > statement status except "-". > > All i want to do is to identify what process makes the other processes > blocked. > > If it's a select from sysmaster table, that would be fine.. if it's onstat, > it > would be fine too. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd4cc14999a97048addf38b

JACK PAPA WROTE: ----------------------------------------------------------------------------- Hi All, Anyone who knows on How to check what processid is blocking another process? I did check using: onstat -g ses xxxxx, where xxxxx is the session id. onstat -g sql xxxxx onstat -u|grep xxxxx I've seen some processes with status "L--BP---" and L--P, these are the process that being blocked.I also noticed that xxxxx process has no "SQL statement status except "-". All i want to do is to identify what process makes the other processes blocked. If it's a select from sysmaster table, that would be fine.. if it's onstat, it would be fine too. ----------------------------------------------------------------------------- Here is the sysmaster query I use... select tabname[1,20], l.owner, s.tty[1,15], pid, l.waiter from syslocks l, syssessions s where waiter is not null and l.owner = s.sid order by 2,4

Thank you Art and Dave. My pleasure having you around to share infos. Regards,

In OAT under the performance menu you can run the report called "Waiting Session Report". John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 07/08/2010 06:37:07 PM: > [image removed] > > Re: How to check what process is blocking another [20555] > > JACK PAPA > > to: > > ids > > 07/08/2010 06:38 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Thank you Art and Dave. My pleasure having you around to share infos. > > Regards, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >