You might want to turn off intra_parallel and change the maxdergee to 1 .







"mireland1" <db2udbdba-ezmlmshield-x13776661.[Email address protected]
04/24/2007 10:24 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Cooking A Processor Please Help






I have a vendor applications that cooks one of our processors at 100%
for about 10 minutes avery few hours. Currently working wirh the vendor
to modify their sql. In the mean time I was wondering if knows of a dbm or
db
cfg change i can do to prevent to cooking of a processor.

aix 5200-08 db2 8.1.12 cpu 9 memory 28 Gig

MAX_QUERYDEGREE = 3
INTRA_PARALLEL = yes

DFT_QUERYOPT = 5
DFT_DEGREE = 1
CHNGPGS_THRESH = 30
NUM_IOCLEANERS = 6
NUM_IOSERVERS = 12

Any ideas would be greatly appreciated
Monty6


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page