RE: Sleeping scan threads

Hi Phil, A couple of people have suggested the patch and I'll give that a shot and hope it helps. The situation I've run into certainly jibes with what other people have experienced and fixed with the patch. Thanks to everyone for their help, Chuck > There is a new patch out from HP you might want to try; I do > not recall the number. There is a mean bug in LVM that makes performance > drop by about 60%;I received this info from Informix. We do not use KAIO > but I believe it applies to both. On large batch jobs there were no bottle > necks but the jobs would take forever to complete. Our V seems to be > cranking it out now since the patch was applied. We have a V2250: 16 gig > of ram; 12 CPU's; 4 gig for Informix; EMC drives. It is tuned for SAP. > Thanks > > Phil Tallent > SAP Administration Informix DBA > (423)-510-7701 FAX (423) 510-7895 > email: phil.tallent@brachs.com > <mailto:phil.tallent@brachs.com> > > > -----Original Message----- > From: Chuck Renaud > [mailto:cjrenaud@sinnfree.org] > Sent: Thursday, May 27, 1999 3:11 PM > To: informix-list@iiug.org > Subject: Sleeping scan threads > > Hello, > > Looking for some general reasons on what > would cause scan > threads to sleep for lengthy amounts of time > when there's no > bottleneck on disk, memory or CPU. > > HP V2250, IDS 7.30.FC3, HP-UX 11, 5 CPUs, > 8GB RAM (5 > allocated to IDS), RAID-5 devices that are > allegedly well-tuned for > read operations. Engine is tuned for DSS, > tables are fragmented > by expression (both elimination and > parallelism are being > achieved), KAIO is enabled, light scans are > occurring, processor > affinity is enabled for all CPUs, no > indexes/all sequential scans. > > TIA, > > Chuck >