Our shop also experienced an unexpected CPU consumption increase after DB2 V9 last year. It's more likely 15% increase via DB2 batch on the first day of upgrade, and was getting reduced gradually with additional memory & our DBA efforts. Finally we admitted approximate 8% increase due to additional functions in 64 bit mode what IBM said. But somehow we still have an unsolved fact that Ave DB2 I/O (via Insight monitor) has been doubled from 0.0035 to 0.0074.
So the elongation of Avg I/O contributes CPU consumption increase??? It's still unknown for our shop since DB2 V9. Anyone can answer this? -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Krister Perrolf Sent: Wednesday, December 10, 2008 8:18 AM To: [email protected] Subject: Increased CPU with z10 and DB2 V9 NFM Hi. Since we started to run our new z10 model 711 and at the same time started DB2 V9 new function mode, we have seen a dramatic increase in CPU consumtion in our 4 production LPAR's. We also have a feeling of not getting the rated performance out of the z10- 711 Has anyone seen or experienced this ? Krister ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html The information transmitted is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use of or the taking of any action in reliance upon this information is prohibited. If you receive this in error, please contact the sender and delete or destroy this message and any copies. The information transmitted is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use of or the taking of any action in reliance upon this information is prohibited. If you receive this in error, please contact the sender and delete or destroy this message and any copies. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html

