Re: concurrency problem in 5.07

robert schmidt wrote: > when more than two queries run concurrently, the response time is > highly degraded. All of the data that the queries are reading > is in informix buffer cache, so there is no i/o time. > The inquiries are read only (cursor stability), > so not too much locking should be taking place.... I'd be interested to see what kind of locking IS taking place. That, and the latching. Have you looked at an onstat -sk? > So far as I can tell, there is nothing interesting in 'sar' reports > when the system is showing this degraded performance. The overall > CPU utilization actually goes down as more processes are run > concurrently. Then it would appear they are all waiting for something. Actually, let me add an onstat -u to the list of interesting output. > The only idea we have at this time is adjusting the 'SPINCNT' configuration > parameter... Perhaps double it to 600. Any thoughts on this idea? That would imply that they are waiting for a lock or a latch. First, you should see what they are waiting for. June -- june_t@hotmail.com Grounded in Palo Alto, living on Oreo's