Re: Performance problem after merging db server

Stephan Stresing (triple-p.sst@t-online.de) wrote: <snip) Try changing your OPTCOMPIND variable to 0 from 2. Take your PDQPRIORITY to about 20% unless you KNOW FOR A FACT that you need to run decision support queries that are designed to use sequential scans. I'd also up the CKPTINTVL to about 1200, reducing the LRU_MAX_DIRTY to 15 and LRU_MIN_DIRTY to 10 (these three will spread your checkpointing activity out and will reduce any long freezes during checkpoints. You said you "consolidated" databases. Are they all using the same sort of logging? If you have four buffered logging dbs and one non-buffered logging one that gets a lot of activity, the non-buffered one can be negating any benefits from the logging ones by forcing writes everytime it needs to do a (nonbuffered) write. Otherwise, I agree with all the other suggestions. Let us know the results. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998 from Prentice Hall/Informix Press. ---------------------------------------------------------------------------