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.