Re: Upgrade from 9.4 to 11.10

Hello Randy, Are you upgrading your hardware, too? If not, then what you have is good (I looked at it fast so I may be missed a few things). I personally like 1 cpuVP per real cpu (or core) for simplicity and price (4 informix licenses instead of 16) but only if performance stays about the same. Your 5 databases in one instance scares me but you probably don't have a choice in that matter. If you are migrating to new hardware, then consider just using your production on it (drop the other DB's) and keep your old (hopefully upgraded) hardware for test and development. And for your DSS queries, try invoking LIGHT SCANS with "export LIGHT_SCANS=FORCE", "SET ISOLATION TO DIRTY READ" and "SET PDQPRIORITY 0". -L.S.

FYI, IBM licenses Informix on the number of cores available on the system NOT the number of CPU VPs you run. If there are 16 cores you pay 16 PVU licenses priced at the number of PVUs each at which the processor is rated. That's regardless of whether you run 1 CPU VP only or 100 CPU VPs per core, the licensing is the same. The only thing you can do is to define a virtual environment which only has access to N cores rather than all of the cores on the system and run the engine within that environment. In that case IBM permits what is known as sub-capacity licensing of the number of virtual CPU cores that the VM is configured to access. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 10, 2009 at 3:14 PM, LIGHT SCANS <light_scans@yahoo.com> wrote: > Hello Randy, > > Are you upgrading your hardware, too? If not, then what you have is > good (I looked at it fast so I may be missed a few things). I > personally like 1 cpuVP per real cpu (or core) for simplicity and > price (4 informix licenses instead of 16) but only if performance > stays about the same. Your 5 databases in one instance scares me but > you probably don't have a choice in that matter. If you are migrating > to new hardware, then consider just using your production on it (drop > the other DB's) and keep your old (hopefully upgraded) hardware for > test and development. > > And for your DSS queries, try invoking LIGHT SCANS with "export > LIGHT_SCANS=FORCE", "SET ISOLATION TO DIRTY READ" and "SET PDQPRIORITY > 0". > > -L.S. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >