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 9 7769
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
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
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 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.
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
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
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.
"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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 easy example.
I have a VB.Net written application that is processor intensive. It has not
been...
|
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 1
user thread), does that mean that processors should be equal or more
|
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
|
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 the right thing.
Would it be possible to "pretend" that the machine does indeed have four
processors...
|
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
| |
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.
|
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
performed in a functional language do not have side effects, and thus
tasks can be divided between...
|
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 what is the better way to
determine the number of CPU sockets in Windows version >= 5 with
a .NET >=...
|
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)?
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |