RE: urgent : Problems with locks

You have got one session holding most of those locks. The owner is1409966a0. This value does not map to the onstat -g sql output. You need to map the owner from onstat -k to the address in onstat -u. The session from onstat -u can then be used in onstat -g ses/sql. Regards, Bill > -----Original Message----- > From: LUQUE Valdivia Omar [SMTP:luque001@marina.mil.pe] > Sent: Thursday, February 26, 2004 2:42 PM > To: informix-list@iiug.org > Subject: urgent : Problems with locks > > Hello every body, > > I have informix 9.21 FC7 on Unix Solaris, in a escenary of three layers, > Client-MTS-BD. > > my problems is the following: > > some sessions are locking a lot of tables, but there are only some selects > or updates, about 5 or 6 only. > All select are very simple... > Before everything was working well > > I don't understand why, my clients are complaining. > > Thanks, > > Omar > << File: onstat_k.txt >> << File: onstat_g_sql.txt >> sending to informix-list

you have problem in application with update statement, if you make update lot of records in one transaction you will get this message because in shared memory is defined maximum # of locks developers have to make short transaction or you can increase # of locks but when you get more records in table you'll have same problem On Thu, 26 Feb 2004 16:44:42 -0500, Bill Dare <dareb@jevic.com> wrote: > >You have got one session holding most of those locks. The owner >is1409966a0. This value does not map to the onstat -g sql output. You need >to map the owner from onstat -k to the address in onstat -u. The session >from onstat -u can then be used in onstat -g ses/sql. > > >Regards, >Bill > > >> -----Original Message----- >> From: LUQUE Valdivia Omar [SMTP:luque001@marina.mil.pe] >> Sent: Thursday, February 26, 2004 2:42 PM >> To: informix-list@iiug.org >> Subject: urgent : Problems with locks >> >> Hello every body, >> >> I have informix 9.21 FC7 on Unix Solaris, in a escenary of three layers, >> Client-MTS-BD. >> >> my problems is the following: >> >> some sessions are locking a lot of tables, but there are only some selects >> or updates, about 5 or 6 only. >> All select are very simple... >> Before everything was working well >> >> I don't understand why, my clients are complaining. >> >> Thanks, >> >> Omar >> << File: onstat_k.txt >> << File: onstat_g_sql.txt >> >sending to informix-list