Open tables and threads

Hi, I have a problem with some blocked transactions, I have looked over onstat -k and onstat -u but doesn't found any waiting case. I have looked over onstat -g opn and I would like to know the smi query or some way to find all the relations to tables and sessions from here. Thanks for any help, SP sergio.peres@airc.pt

Hola Sergio, buen dìa, yo corro el siguiente query en la sysmaster, en un IDS 9.4 select s1.username,s1.sid,waiter,s2.username,dbsname,tabname, rowidlk,keynum,type,s1.pid from sysmaster:syslocks l, sysmaster:syssessions s1, syssessions s2 where s1.sid = l.owner and waiter = s2.sid and waiter > 0 Saludos Susana Barea Mendoza Argentina ----- Mensaje original ----- De: "SERGIO PERES" <sergio.peres@airc.pt> Para: ids@iiug.org Enviados: Viernes, 15 de Mayo 2015 8:12:48 Asunto: Open tables and threads [35101] Hi, I have a problem with some blocked transactions, I have looked over onstat -k and onstat -u but doesn't found any waiting case. I have looked over onstat -g opn and I would like to know the smi query or some way to find all the relations to tables and sessions from here. Thanks for any help, SP sergio.peres@airc.pt ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Using onstat, run onstat -u and grep for the non-zero digits of the rstcb column from onstat -g opn. This will give you the session id in column 3. Using sysmaster, convert the rstcb column value to decimal and search sysrstcb: select * from sysrstcb where sid = <the decimal rstcb value>; or using the tid column value: select * form sysrstcb where tid = <value>; Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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 Fri, May 15, 2015 at 7:12 AM, SERGIO PERES <sergio.peres@airc.pt> wrote: > Hi, > > I have a problem with some blocked transactions, I have looked over onstat > -k > and onstat -u but doesn't found any waiting case. I have looked over > onstat -g> opn and I would like to know the smi query or some way to find all the > relations to tables and sessions from here. > > Thanks for any help, > > SP > sergio.peres@airc.pt > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0116197ac5aad105161d8f93