Re: lchwaits problem!!!!

Posted in 1998

Sean Kelsey — Fri, 4 Dec 1998 10:12:43 -0000 — source: Informix-list mailing list archive (1991-1998)

Having read your posting properly... The lchreqs and lchwaits fields from the tbstat -p command store the number of requests for a latch and the number of times that a thread was required to wait for a shared-memory latch. A large number of latch waits typically results from a high volume of processing activity in which the database server is logging most of the transactions. Unfortunately, the administrator cannot configure or tune the number of latches; the database server sets this function internally. Oh dear !!! Sean Goldy Magaly Pastor Murillo wrote in message <7469tr$1hf$1@news.xmission.com>... > >My plataform > >SCO OpenServer 5.0.4 >OnLine 5.01 > >Lalety my system become very slow.. when this happends I run tbstat -p, and >notice that lchwaits increases.. anybody knows what I have to do to solve >this problem > >TIA > >Goldy >********************************************* >Goldy Pastor Murillo >Consultora > >Proyecto ILACO >e-mail: gpastor@ilaco.gov.bo > goldypm@yahoo.com >www : www.ilaco.gov.bo >Telf : 591-2-372703 >La Paz - Bolivia >*********************************************