If you application is not a DW application, may I suggest that you turn INTRA_PARALLEL = no, and bounce the database. INTRA_PARELLEL = yes can suck your CPUs dry...

When we tuned an OLTP database years back, we thought of all the things we needed to do to improve performance. One among them was setting INTRA_PARELLEL = yes. It was years afterwards we found out that INTRA_PARELLEL = no made vast CPU improvements.

Please let me know if this suggestion helps and how much.

Thanks.

Tonmoy Dasgupta.


----- Original Message -----
From: mireland1
Date: Tuesday, April 24, 2007 9:24 am
Subject: Cooking A Processor Please Help
To: LazyDBA Discussion

> I have a vendor applications that cooks one of our processors at
> 100%
> for about 10 minutes avery few hours. Currently working wirh the
> vendorto 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