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

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

db2inst2@gmail.com (db2inst2) wrote in message news:<10084fa9.0411101934.753dca7f@posting.google. 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
>
> db2inst2@gmail.com (db2inst2) wrote in message news:<10084fa9.0411101934.753dca7f@posting.google. 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

db2inst2@gmail.com (db2inst2) wrote in message news:<10084fa9.0411101934.753dca7f@posting.google. 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

yasaswi@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa862233.0411110251.8032479@posting.google.c om>...
> Are you sure you have the right number of processor licenses for DB2?
> You would need 8 processor license I think.
> Yasaswi
>
> db2inst2@gmail.com (db2inst2) wrote in message news:<10084fa9.0411101934.753dca7f@posting.google. 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...

db2inst2@gmail.com (db2inst2) wrote in message news:<10084fa9.0411101934.753dca7f@posting.google. 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" <db2inst2@gmail.com> wrote in message
news:10084fa9.0411101934.753dca7f@posting.google.c om...
> 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 <sescons@attglobal.net> wrote in message news:<4193DA01.4070502@attglobal.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