RE: Upgrade from 9.4 to 11.10

Hardware is same (no hardware upgrade, just changing versions on existing equipment) and licensing taken care of, just looking for feedback/suggestions for onconfig parameters. Thanks, Randy From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Art Kagel Sent: Tuesday, November 10, 2009 1:42 PM To: LIGHT SCANS Cc: informix-list@iiug.org Subject: Re: Upgrade from 9.4 to 11.10 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