Urgent Help - Limit to use CPU 1

[Vijai Kumar]

Hi,

Is is possible to limit the UDB DB2 to use only 1 cpu on the 2 cpu server.

Can you please provide me the steps or link where I could get the info.

Thanks
vijai

[Jean-David Beyer]

Vijai Kumar wrote:

Hi,

Is is possible to limit the UDB DB2 to use only 1 cpu on the 2 cpu server.

Can you please provide me the steps or link where I could get the info.

Thanks
vijai

I believe that is the default.

To make it use more, you must set

INTRA_PARALLEL to YES
and
MAX_QUERYDEGREE to something, such as ANY
in the Database Manager Configuration.

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 07:05:00 up 2 days, 14:34, 3 users, load average: 1.03, 0.62, 0.27

[Mark A]

"Jean-David Beyer" <jd*****@exit109.com> wrote in message
news:10*************@corp.supernews.com...

Vijai Kumar wrote:

Hi,

Is is possible to limit the UDB DB2 to use only 1 cpu on the 2 cpu server.
Can you please provide me the steps or link where I could get the info.
Thanks
vijai

I believe that is the default.

To make it use more, you must set

INTRA_PARALLEL to YES
and
MAX_QUERYDEGREE to something, such as ANY
in the Database Manager Configuration.

--
.~. Jean-David Beyer Registered Linux User 85642.

That limits intra-partition parallelism on a single query, but does not
limit DB2 itself from using both processors for different tasks. I suspect
this is a licensing issue.

[Fabrizio]

hello,
try with this command:
db2licm -n <product password> 1
(ie: db2licm -n DB2ESE 1 )
you can find the product password issuing db2licm -l

bye, Fab

"Vijai Kumar" <vi***********@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

Hi,

Is is possible to limit the UDB DB2 to use only 1 cpu on the 2 cpu server.
Can you please provide me the steps or link where I could get the info.
Thanks
vijai

[Larry]

I believe this is only controllable via the underlying OS, and possibly
some DB2 environment variables. Don't think db2licm will alter this
behavior. What os/hw are you using?

Larry Edelstein

Fabrizio wrote:

hello,
try with this command:
db2licm -n <product password> 1
(ie: db2licm -n DB2ESE 1 )
you can find the product password issuing db2licm -l

bye, Fab

"Vijai Kumar" <vi***********@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

Hi,

Is is possible to limit the UDB DB2 to use only 1 cpu on the 2 cpu

server.

Can you please provide me the steps or link where I could get the

info.

Thanks
vijai

[Knut Stolze]

Larry wrote:

I believe this is only controllable via the underlying OS, and possibly
some DB2 environment variables. Don't think db2licm will alter this
behavior. What os/hw are you using?

The way I understood recent discussions on the very same topic is that there
is no way to force DB2 to use only one or two processors. DB2 will use all
processors that are available from the operating system. So you will have
to control/partition the processor usage already on a lower level. If your
OS does not yet supply such a feature, then you can't do what the OP wanted
to do.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Jean-David Beyer]

Knut Stolze wrote:

Larry wrote:

I believe this is only controllable via the underlying OS, and possibly
some DB2 environment variables. Don't think db2licm will alter this
behavior. What os/hw are you using?

The way I understood recent discussions on the very same topic is that there
is no way to force DB2 to use only one or two processors. DB2 will use all
processors that are available from the operating system. So you will have
to control/partition the processor usage already on a lower level. If your
OS does not yet supply such a feature, then you can't do what the OP wanted
to do.

In Linux, can you not use affinity to bind a process to a particular
processor? I have never tried it, but it should work. Of course, DB2 runs
a lot of processes and that would open up the question of what the O.P.
means by limiting DB2 to one CPU.

For example, on my main database, I have 7 page fetchers and 7 page
cleaners. I suppose I could limit them all to the same one CPU (though in
that case, perhaps I should set it up to have only one of each).

I.e., what does the O.P. really want to accomplish?

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 13:25:00 up 2 days, 20:54, 4 users, load average: 1.60, 0.93, 0.78

[Mark A]

> In Linux, can you not use affinity to bind a process to a particular

processor? I have never tried it, but it should work. Of course, DB2 runs
a lot of processes and that would open up the question of what the O.P.
means by limiting DB2 to one CPU.

For example, on my main database, I have 7 page fetchers and 7 page
cleaners. I suppose I could limit them all to the same one CPU (though in
that case, perhaps I should set it up to have only one of each).

I.e., what does the O.P. really want to accomplish?

--
.~. Jean-David Beyer Registered Linux User 85642.

Usually these questions are to allow one to only pay a one processor DB2
license charge while running a multi-processor machine. But there are some
DB2 license options available which are by number of connected users,
instead of processors, if the number of processors is 4 or less. With
connection pooling, a small number of simultaneous connections can work
fine, or one can get a license for unlimited connections (without paying the
per processor charge).