473,573 Members | 2,510 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 not using all processors

Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks
Nov 12 '05 #1
9 7734
Are you sure you have the right number of processor licenses for DB2?
You would need 8 processor license I think.
Yasaswi

db******@gmail. com (db2inst2) wrote in message news:<10******* *************** ****@posting.go ogle.com>...
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks

Nov 12 '05 #2
DB2 8.2 express supports 2 CPUs
Workgroup supports 4 CPUs
Enterprise..... well a lot more.

Make sure you have the right version to support the number of CPUs you have.

That being said, make sure you have parallelism turned on.

Christos Kalantzis


db2inst2 wrote:
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks

Nov 12 '05 #3
I don't believe that this will affect the number of processors that DB2
uses.

Larry Edelstein

Yasaswi Pulavarti wrote:
Are you sure you have the right number of processor licenses for DB2?
You would need 8 processor license I think.
Yasaswi

db******@gmail. com (db2inst2) wrote in message news:<10******* *************** ****@posting.go ogle.com>...
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_paralle l system
dft_degree -1

NUM_IOCLEANER S 30
CHNGPGS_THRES H 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks


Nov 12 '05 #4
db******@gmail. com (db2inst2) wrote in message news:<10******* *************** ****@posting.go ogle.com>...
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks


Not directly related to your CPU issue, but you should probably change
your parms as follows:

NUM_IOCLEANERS 8
CHNGPGS_THRESH 40
LOCKLIST 4096
LOGBUFSZ 128 (or higher)

It will help if you use multiple containers per tablespace, but only
if each container is on a different RAID array or physical drive (if
you are using JBOD). Then make your prefetch size n times the extent
size (where n is the number of containers in each tablespace).

I don't think you can use WSE for 8 processor machines, but there may
also be a license issue also.
Nov 12 '05 #5
I do have the license. And updated it with db2licm.

And the version of db2 is ESE 8.2

Thanks

ya*****@encfor. com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ***@posting.goo gle.com>...
Are you sure you have the right number of processor licenses for DB2?
You would need 8 processor license I think.
Yasaswi

db******@gmail. com (db2inst2) wrote in message news:<10******* *************** ****@posting.go ogle.com>...
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks

Nov 12 '05 #6
You could check if every CPU is used in its own window. Try some big
and complicated query...

db******@gmail. com (db2inst2) wrote in message news:<10******* *************** ****@posting.go ogle.com>...
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks

Nov 12 '05 #7
Check the following
dbm cfg
INTRA_PARALLEL ON
MAX_QUERYDEGREE -1 or ANY 0r 8
db cfg
DFT_DEGREE -1 or ANY or 8

Those parms. affect whether or not multiple cpus will be used and how many.
All the other parms. affect capacity management issues WHEN you are
using multiple cpus not how many.

Given that you have ESE installed, and you are licensed for, that
version can use as many processors as you will make available.

db2inst2 wrote:
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #8

"db2inst2" <db******@gmail .com> wrote in message
news:10******** *************** ***@posting.goo gle.com...
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.


I don't believe IMPORT pays heed to INTRA_PARALLEL, and thus will only end
up one CPU.

You have two options:
1) split your input file into multiple smaller files and run multiple IMPORT
sessions in parallel by hand
2) use LOAD, which will parallelize internally and make batter use of your
CPUs

--
Matt Emmerton
Nov 12 '05 #9
I changed all these parameters.

But still no luck for imports.

When i do some exports all cpu's are used and its faster than doing
exports on a single cpu machine.

when i tried dividing the imports into 4 and ran them simultaneously
it was better. But still only 4 cpu's are used.

Is there something with imports, that it can't make use of multiple
cpus

Thanks for your responses.
Pierre Saint-Jacques <se*****@attglo bal.net> wrote in message news:<41******* *******@attglob al.net>...
Check the following
dbm cfg
INTRA_PARALLEL ON
MAX_QUERYDEGREE -1 or ANY 0r 8
db cfg
DFT_DEGREE -1 or ANY or 8

Those parms. affect whether or not multiple cpus will be used and how many.
All the other parms. affect capacity management issues WHEN you are
using multiple cpus not how many.

Given that you have ESE installed, and you are licensed for, that
version can use as many processors as you will make available.

db2inst2 wrote:
Hi all,

I have DB28.2 running on win2003 system which has 8 Processors with HT
its 16

How do i make DB2 more use of all the processors?

Right now i am doing an import and task manager shows almost 100%
usage of just one CPU and everything else is idle. (Overall CPU usages
is less than 10%)

This is how my CFG looks like (Changed Specifically for import)

intra_parallel system
dft_degree -1

NUM_IOCLEANERS 30
CHNGPGS_THRESH 5
DBHEAP 3000
LOCKLIST 300
LOGRETAIN OFF
USEREXIT OFF

Tablespaces are DMS

Is there anything else i should do achieve this.

Thanks

Nov 12 '05 #10

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

Similar topics

2
2092
by: JohnFol | last post by:
I know Windows / SQL etc can utilise multiple processors. In the good old days of coding, you simply wrote the .EXE and Windows would run it on a single processor (or a given processor for multi-processor machines) I know also that threads exist, but am having a few problems understanding how they are split across processors so here is an...
2
2730
by: nagaraj_hayyal | last post by:
Hi All, thanks for reading this post. just wanted to know about the ratio of threads and processors. i am working on c++ on AIX5.2 platform. my c++ program are multithreaded programs. In a multithreaded application,should no of processors be equal to no of threads ? if we set the thread_scope to system( meaning 1 kernel thread to...
3
2122
by: nrhayyal | last post by:
Hi All, thanks for reading this post. just wanted to know about the ratio of threads and processors. i am working on c++ on AIX5.2 platform. my c++ program are multithreaded programs. In a multithreaded application,should no of processors be equal to no of threads ? if we set the thread_scope to system( meaning 1 kernel thread to 1
2
1996
by: mairhtin o'feannag | last post by:
Hello, I am a bit confused as to how this all works with respect to number of processors on a Linux machine. The situation I am encountering is this : because of Hyperthreading technology, the OS thinks it has four processors, but in reality, it has only two. I have updated the db2licm to use two processors, but want to be certain I did...
17
1456
by: RayAll | last post by:
I'm having a webserver with 2 processors .I read an article somewhere that state mamangement on 2 processors in an ASP.NET application is different with one processor.Is that right? Thanks
2
2673
by: webwarrior | last post by:
Hi, Is there a reason why we have to pay more for licensing for a different kind of processor? Why are we not charged for the Hyperthreading on some processors also. If Oracle is really conserned about the low end business market (small and medium), then they should drop their attitude on Dual Core processors.
5
1802
by: shumaker | last post by:
I just read an overview of C# 3.0, and it occured to me that some of these features could make it much easier to write programs that automatically make use of multi core processors. After reading that lambda functions are available in 3.0, I read up on the advantages of functional programming, and one of the advantages is that tasks...
12
2382
by: not_a_commie | last post by:
Is using System.Management in general a faux pas? It seems, after some web searching, that there is a fair amount of resistance to it because of speed and portability. I need to know how many CPU sockets there are. I'm using System.Management to do this. It takes about two seconds to do this. (Which, yes, is full-on crap for speed.) But...
11
4905
by: John | last post by:
Is there a way to find the number of processors on a machine (on linux/ windows/macos/cygwin) using python code (using the same code/cross platform code)?
0
7746
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7668
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7983
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7735
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5556
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5257
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3694
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2166
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1269
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.