473,385 Members | 1,338 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Using single processor license on multiprocessor machine

We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

Does anyone know whether it is possible to
buy a single processor db2 license for this machine
and to configure the db2 software with db2licm just
to use one processor.

Therefore, we would be lucky in saving half of license costs.

I had a look at the IBM site and at google but I havent
found any information at that topic.

Could you please provide me an URL to the IBM site where
I can get info about that ?

Thanx in advance !!
Nov 12 '05 #1
5 5206
No, you cannot use db2licm to tell db2 to ignore a processor(s).
I am not an AIX expert but perhaps you can create an LPAR that uses
just one processor?
If the db2 instance runs here it can only use that one processor.
Not sure though is this is confirming the db2 license rules.

dba_db2 at nospam gmx.net wrote:
We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

Does anyone know whether it is possible to
buy a single processor db2 license for this machine
and to configure the db2 software with db2licm just
to use one processor.

Therefore, we would be lucky in saving half of license costs.

I had a look at the IBM site and at google but I havent
found any information at that topic.

Could you please provide me an URL to the IBM site where
I can get info about that ?

Thanx in advance !!


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
Nov 12 '05 #2
PS. you can start at www.ibm.com/software/data

dba_db2 at nospam gmx.net wrote:
We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

Does anyone know whether it is possible to
buy a single processor db2 license for this machine
and to configure the db2 software with db2licm just
to use one processor.

Therefore, we would be lucky in saving half of license costs.

I had a look at the IBM site and at google but I havent
found any information at that topic.

Could you please provide me an URL to the IBM site where
I can get info about that ?

Thanx in advance !!


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
Nov 12 '05 #3
I don't know if IBM has any LPAR-based pricing yet. But certainly
withouth an LPAR, you must license all the processors on the server.

Larry Edelstein

dba_db2 at nospam gmx.net wrote:
We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

Does anyone know whether it is possible to
buy a single processor db2 license for this machine
and to configure the db2 software with db2licm just
to use one processor.

Therefore, we would be lucky in saving half of license costs.

I had a look at the IBM site and at google but I havent
found any information at that topic.

Could you please provide me an URL to the IBM site where
I can get info about that ?

Thanx in advance !!


Nov 12 '05 #4
db*****@gmx.net (dba_db2 at nospam gmx.net) wrote in message news:<6f*************************@posting.google.c om>...
We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

Does anyone know whether it is possible to
buy a single processor db2 license for this machine
and to configure the db2 software with db2licm just
to use one processor.

Therefore, we would be lucky in saving half of license costs.

I had a look at the IBM site and at google but I havent
found any information at that topic.

Could you please provide me an URL to the IBM site where
I can get info about that ?

Thanx in advance !!


The license according to IBM does not allow to run DB2 on a 2/multi
CPU machine (assuming the cpus in one partition= 1 logical machine)
with a 1 cpu license (unless it is a recovery machine).

DB2 for the moment will not enforce this rule, so it can be started
with a single processor license on a multi-cpu machine (in 1 logical
machine again).
On pSeries/AIX there is the bindprocessor command that allows to bind
processes at runtime to a cpu, fork/exec inherits it, so binding the
instance processes after start to one cpu will help in this case.
Clients if DB2 EE is used are not limited -they can even connect from
other systems- so binding to a processor would not be necessary for
the clients. Usage of WLM is also possible, to limit the db2 part to
50% (again 1 cpu usage on 2 cpus).

I do not say licenses are not to be respected, this is a ... customer
decision as long as the vendor does not enforce its rules. There are
ways to respect licenses on a creative manner in the AIX/Unix world.
Not only IBM, also internal auditors could disagree!
Bernard Dhooghe
Bernard Dhooghe
Nov 12 '05 #5
no***@attglobal.net (Bernard Dhooghe) wrote in message news:<25**************************@posting.google. com>...
db*****@gmx.net (dba_db2 at nospam gmx.net) wrote in message news:<6f*************************@posting.google.c om>...
We have got a brand new mutltiprocessor machine
IBM pseries server with 2 processors.
Now we want to buy a IBM DB2 license for this
box.

Does anyone know whether it is possible to
buy a single processor db2 license for this machine
and to configure the db2 software with db2licm just
to use one processor.

Therefore, we would be lucky in saving half of license costs.

I had a look at the IBM site and at google but I havent
found any information at that topic.

Could you please provide me an URL to the IBM site where
I can get info about that ?

Thanx in advance !!


The license according to IBM does not allow to run DB2 on a 2/multi
CPU machine (assuming the cpus in one partition= 1 logical machine)
with a 1 cpu license (unless it is a recovery machine).

DB2 for the moment will not enforce this rule, so it can be started
with a single processor license on a multi-cpu machine (in 1 logical
machine again).
On pSeries/AIX there is the bindprocessor command that allows to bind
processes at runtime to a cpu, fork/exec inherits it, so binding the
instance processes after start to one cpu will help in this case.
Clients if DB2 EE is used are not limited -they can even connect from
other systems- so binding to a processor would not be necessary for
the clients. Usage of WLM is also possible, to limit the db2 part to
50% (again 1 cpu usage on 2 cpus).

I do not say licenses are not to be respected, this is a ... customer
decision as long as the vendor does not enforce its rules. There are
ways to respect licenses on a creative manner in the AIX/Unix world.
Not only IBM, also internal auditors could disagree!
Bernard Dhooghe
Bernard Dhooghe

Thanks a lot for your contributions to the thread.
We have ordered a unlimited wg licencse for 2 processors.
Nevertheless its much cheaper than a oracle license for
a single processor machine.
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Tomer Ben-David | last post by:
Hi I have a big j2ee appliction that was so forth run on a single cpu machine. I have tested it on a dual cpu machine, its running much slower (about X3 times slower). I know that...
5
by: M Wells | last post by:
Hi All, Just wondering if it's any more efficient to use the following SQL statement to return a partial match from a column as opposed to the second statement. SELECT * FROM Table1 WHERE...
0
by: joshsackett | last post by:
Hi all, I'm in the market to purchase 10 SQL 2000 Enterprise processor licenses. Since License Agreement restrictions prevent the creation of a secondary market I am turning to people who may know...
6
by: m | last post by:
Hello, I have an application that processes thousands of files each day. The filenames and various related file information is retrieved, related filenames are associate and placed in a linked...
8
by: 1qa2ws | last post by:
Hi, who can use MSDE 2000? If I develope an application with C# having MS Visual C# .NET 2003 Standard which uses SQL Server, can I distribute my application with MSDE? 1qa2sw
0
by: jacky shi | last post by:
Hi,all: I find a problem in my program related with multiprocessor.The OS is windows, and when it run on a singleprocessor machine, it's OK. But If the machine is multiprocessor, there will be...
1
by: booksnore | last post by:
Hi, I have a console application in C# which I run as an exe. The server on which the application runs has four processors but the application only uses one processor. Is there any way I can get...
20
by: bubunia2000 | last post by:
Hi all, I heard that strtok is not thread safe. So I want to write a sample program which will tokenize string without using strtok. Can I get a sample source code for the same. For exp:...
0
by: vijayasb | last post by:
Hi, I am using GetProcessTimes() API to calculate CPU usage of a process. In single processor system i get correct result , but in multiprocessor system i will get some abrupt and negative...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.