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

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