RE: who locks a record?

Posted in 2006

Willaert Doris — Mon, 8 May 2006 11:28:40 +0200 — source: Usenet: comp.databases.informix

DATABASE sysmaster; SELECT distinct tabname,sysuserthreads.us_name,dbsname,syssessions.pid FROM syslocks,sysuserthreads,syssessions WHERE sysuserthreads.us_sid = syslocks.owner AND syssessions.sid = sysuserthreads.us_sid AND tabname not matches "sys*" -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Danny De Koster Sent: maandag 8 mei 2006 11:18 To: informix-list@iiug.org Subject: who locks a record? Hi all, Is there a way to know who is locking a certain record in the table? OS: SuSe IDS: 9.40.UC2 thanks! Danny _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Willaert Doris

Danny De Koster — Mon, 8 May 2006 11:40:36 +0200 — source: Usenet: comp.databases.informix

thanks guys!! "Willaert Doris" <Doris.Willaert@alcopa2wheels.com> schreef in bericht news:mailman.136.1147080500.848.informix-list@iiug.org... DATABASE sysmaster; SELECT distinct tabname,sysuserthreads.us_name,dbsname,syssessions.pid FROM syslocks,sysuserthreads,syssessions WHERE sysuserthreads.us_sid = syslocks.owner AND syssessions.sid = sysuserthreads.us_sid AND tabname not matches "sys*" -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Danny De Koster Sent: maandag 8 mei 2006 11:18 To: informix-list@iiug.org Subject: who locks a record? Hi all, Is there a way to know who is locking a certain record in the table? OS: SuSe IDS: 9.40.UC2 thanks! Danny _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list