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