Re: very bad behavior

Posted in 2007

Art S. Kagel — Mon, 29 Jan 2007 15:13:21 -0500 — source: Usenet: comp.databases.informix

tomcaml@gmail.com wrote: > Hi all, > We finished a major migration a few weeks ago but the new system is > really misbehaving. Any thoughts are appreciated. Here is the low down. > The new dev system behaves fine but not on primary and secondary. We > have tried tuning many different things and running update stats many > different ways. > on dev, OPTCOMPIND is 0, and it is 0 on secondary and it is 2 on > primary. > > Old system : IDS v10.fc4 with HDR on HP-UX 11i > New Prod system: LPAR partitions on i595 servers IDS v10.fc5 with HDR > New Dev system: LPAR partitions on i595 servers IDS v10.fc5 > > <SNIP> Set OPTCOMPIND to 0 on production primary also and make sure that data distributions (UPDATE STATISTICS) have been calculated to at least the levels recommended in the Performance Guide. Art S. Kagel