Sounds like you also need to familiarise yourself with how DIST works - meaning enclaves that run the actual DDF SQL. As I say, unlikely DIST itself but rather more likely the DDF is "in play".
Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: [email protected] Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: L Hagedorn <[email protected]> To: [email protected] Date: 17/12/2014 16:08 Subject: Re: MIPS, CEC, LPARs, PRISM, WLM Sent by: IBM Mainframe Discussion List <[email protected]> MVS Sysprogs reported the situation saying DB2DIST on LPAR A was affecting LPAR B. I didn't ask them for doc, but will next time. This is a runtime issue, unrelated to reported changes. That being said, I'm aware WLM is changed frequently and without broadcast notification. This appears from time to time. I am new here (couple of months) so cannot determine how long its been happening - could be months, could be years. I need to understand the interworkings of prism, WLM, and the LPARs, and from the postings today, more about soft and hard capping. All input is appreciated. I have a learning curve in this area, so telling me to look for something in RMF is welcome, along with any display commands where I can see the caps. I have Mainview. Sent from my iPhone On Dec 17, 2014, at 8:35 AM, Lizette Koehler <[email protected]> wrote: > I would ask first, how do you know it is affecting the Prod LPAR. > > What evidence, RMF Reports, Performance monitors, etc. ? > > There should be, I think, so data that could explicitly show that is what is > happening. > > Is it all the time, some of the time? Is it a specific time when the prod > LPAR is affected? How long has it been going on? Is there a point in time > when this started? If so, what changes occurred at that point? > > Lizette > > >> -----Original Message----- >> From: IBM Mainframe Discussion List [mailto:[email protected]] On >> Behalf Of L Hagedorn >> Sent: Wednesday, December 17, 2014 5:44 AM >> To: [email protected] >> Subject: MIPS, CEC, LPARs, PRISM, WLM >> >> Hi IBM-MAIN, >> >> We have a situation with multiple LPARS on a CEC, running DB2 asids prod, > test, >> dev. >> >> It is claimed a runaway DB2 DIST asid on the DVLP LPAR is burning CPU and >> stealing MIPS from the PROD LPAR and affecting production. >> >> Others claim this is not possible due to Prism. >> >> Will someone provide an overview of how Prism influences or controls MIPS > usage >> (CPU) across LPARs sharing the same CEC, what are the limiting or > controlling >> factors (if any), and how can the behavior be measured or reported upon so > I can >> explain this with supporting doc? Does WLM play a part in sharing CPU > across >> LPARs? >> >> Any information or referrals to doc is appreciated. >> >> Thanks, Linda > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
