table lock

Hi, I have some situation here. One of the applications is locking rows in one table. From the application side, we see message "244 : Could not do a physical-order read to fetch next row. 107 : ISAM error: record is locked." Here is the output from "onstat -k". informix@ifx01:/home/informix/log/ipdb >onstat -k IBM Informix Dynamic Server Version 7.31.UD10 -- On-Line -- Up 00:12:57 -- 1905888 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 318298c8 0 90065878 0 S 100002 203 0 34037860 0 90066280 0 S 100002 203 0 3543e688 0 0 0 HDR+IX 400052 0 0 3543e6c0 0 0 3543e688 HDR+X 400052 101 0 368455c8 0 90067b94 0 HDR+S 100002 203 0 36845718 0 90066c88 0 S 100002 203 0 37c4c508 0 9006496c 0 S 100002 203 0 39053480 0 9006496c 37c4c508 HDR+IS 400019 0 0 8 active, 3000000 total, 262144 hash buckets The interesting thing is that the owner of "0". Called IBM, even they have no idea what does that mean. I try to restart the IDS for several times, and the lock still there. Does anybody have same experience? And how to solve it? Thanks, Denny

Denney, What is your output of "onstat -u"? Frank On 8/20/07, Guo, Denny <DGuo@livingstonintl.com> wrote: > > Hi,Denny, I have some situation here. > One of the applications is locking rows in one table. From the > application side, we see message "244 : Could not do a physical-order > read to fetch next row. 107 : ISAM error: record is locked." > > Here is the output from "onstat -k". > > informix@ifx01:/home/informix/log/ipdb >onstat -k > > IBM Informix Dynamic Server Version 7.31.UD10 -- On-Line -- Up > 00:12:57 -- 19> 05888 Kbytes > > Locks > address wtlist owner lklist type tblsnum rowid key#/bsiz > 318298c8 0 90065878 0 S 100002 203 0 > 34037860 0 90066280 0 S 100002 203 0 > 3543e688 0 0 0 HDR+IX 400052 0 0 > 3543e6c0 0 0 3543e688 HDR+X 400052 101 0 > 368455c8 0 90067b94 0 HDR+S 100002 203 0 > 36845718 0 90066c88 0 S 100002 203 0 > 37c4c508 0 9006496c 0 S 100002 203 0 > 39053480 0 9006496c 37c4c508 HDR+IS 400019 0 0 > 8 active, 3000000 total, 262144 hash buckets > > The interesting thing is that the owner of "0". Called IBM, even they > have no idea what does that mean. > I try to restart the IDS for several times, and the lock still there. > Does anybody have same experience? And how to solve it? > > Thanks, > Denny > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Thanks for reply. "Onstat -u" does not show the address of "0". Restart the client application seems solves the problem. Regards, Denny -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Monday, August 20, 2007 3:36 PM To: ids@iiug.org Subject: Re: table lock [9822] Denney, What is your output of "onstat -u"? Frank On 8/20/07, Guo, Denny <DGuo@livingstonintl.com> wrote: > > Hi,Denny, I have some situation here. > One of the applications is locking rows in one table. From the > application side, we see message "244 : Could not do a physical-order > read to fetch next row. 107 : ISAM error: record is locked." > > Here is the output from "onstat -k". > > informix@ifx01:/home/informix/log/ipdb >onstat -k > > IBM Informix Dynamic Server Version 7.31.UD10 -- On-Line -- Up > 00:12:57 -- 19> 05888 Kbytes > > Locks > address wtlist owner lklist type tblsnum rowid key#/bsiz > 318298c8 0 90065878 0 S 100002 203 0 > 34037860 0 90066280 0 S 100002 203 0 > 3543e688 0 0 0 HDR+IX 400052 0 0 > 3543e6c0 0 0 3543e688 HDR+X 400052 101 0 > 368455c8 0 90067b94 0 HDR+S 100002 203 0 > 36845718 0 90066c88 0 S 100002 203 0 > 37c4c508 0 9006496c 0 S 100002 203 0 > 39053480 0 9006496c 37c4c508 HDR+IS 400019 0 0 > 8 active, 3000000 total, 262144 hash buckets > > The interesting thing is that the owner of "0". Called IBM, even they > have no idea what does that mean. > I try to restart the IDS for several times, and the lock still there. > Does anybody have same experience? And how to solve it? > > Thanks, > Denny > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.