Re: performance turning help

Wayne, It is also recommended to let the fist cpu to the system, you use only 2 cpus on the 3 you have, but you should bound the 2 informix dedicated by using the : AFF_SPROC 1 AFF_NPROCS 2 I also have the same kind of machine (SUN 450 4 cpu) and I'm also trying to optimize my informix db 9.14UC2, we can stay in touch to give each other the improvements or damage we do changing our parameters?! Karim. -- __________________________________________________ La meteo par le Web : http://www.meteoconsult.fr Meteo Consult - Bureau d'etudes meteorologiques Domaine de Marsinval F-78540 Vernouillet, FRANCE Karim BEN GHANEM - mailto:kbg@meteoconsult.fr Departement Informatique tel : +33 1 39 65 80 80 - fax : +33 1 39 65 80 96