[Info-ingres] Reducing the number of CPUs in an Ingres Installation

[Steve]

On Friday, October 16, 2020 at 5:52:04 PM UTC+11, Martin Bowes wrote:
> Hi Steve, 
> 
> License time is it? 

Thanks Martin. 

Not yet - I think it's COVID time.

> There is no way from the ingres end to restrict the number of CPU's you are executing on. If the box presents 20cpu...you're going to use them, and pay for them. 

Understood. The Ingres installation runs on a virtual machine, so the idea is to reduce the number of CPUs available to the virtual machine to reduce licencing costs.

Apart from the licence (and associated XML licence file) and the potential performance impact, would there be any implications from an Ingres perspective in reducing the number of CPUs? I had the same impression Martin, that Ingres will use whatever number of processors you present to it. For example, will reducing the number of CPUs require me to re-install Ingres or unload the database?

I see from the Installation Guide there is an Ingres environment variable II_NUM_OF_PROCESSORS - it's set to 2 in the installation, which bares absolutely no resemblance to the number of CPUs! :o

> Your operating system *may* allow some form of restriction to tie a process to a certain number of CPU, but lichostinfo won't pick that up. 
> 
> Your best option is to deploy a host with a restricted number of cpu. Be aware the minimum number from a license PoV is 2. 

OK.

Thanks
Steve