Re: Add Storage To Lpar - z/800
Indeed. Most have a hard time with the phenomena that I/O is actually pretty CPU intensive. Adding real storage won't help much: it is the exploitation of the real that is available. Look for buffer/cache hits in the high 90% range. For a read intensive application, 99% buffer hit rate may be a doable target. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ed Finnell Sent: Wednesday, November 26, 2008 12:05 AM To: IBM-MAIN@bama.ua.edu Subject: Re: Add Storage To Lpar - z/800 In a message dated 11/25/2008 2:30:08 P.M. Central Standard Time, [EMAIL PROTECTED] writes: knee of the curve - but the curve for what? DB/2 lives in Buffer pool city. The first bottle neck is underallocated pools. Lots of tuning opportunities. Craig Mullin's(formerly with Platinum) book is a good starting point. The CA Platinum tools gave us the best feedback for systems and DBA's. NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all 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
Re: Add Storage To Lpar - z/800
Our DBA has been looking at increasing several of the buffer pools. I know he said that buffer/cache hits was in the 60% range on Monday. He did 2 rounds of tuning, including bouncing the DB2 region last night. DB2 is shut down usually only on the weekend with our weekly IPL. The problem we have is that this whole week there is a lower volume due to the Thanksgiving holiday, so the testing today won't have the volume we need. Eric Hal Merritt [EMAIL PROTECTED] wrote: Indeed. Most have a hard time with the phenomena that I/O is actually pretty CPU intensive. Adding real storage won't help much: it is the exploitation of the real that is available. Look for buffer/cache hits in the high 90% range. For a read intensive application, 99% buffer hit rate may be a doable target. -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- 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
Add Storage To Lpar - z/800
Can real storage be added to an Lpar on a z/800 without shutting down the Lpar and re-IPLing? We have 4 Lpars defined, only two of them running now. Both Lpars have 3G of memory. I think the 2 Lpars that aren't running have .5G each. I know we have a little less than 1G that is free and unassigned, so I'm wondering if I can add that to our production DB2 lpar without having to IPL? We just installed DB2 V8 in compatiblity mode. Response time went from .5 seconds average to 1.2 seconds. No one has been complaining, but this is a week that many people have taken off, so volume is down. We have to get a handle on this by the end of tomorrow, as we are closed Thursday and Friday. We have a DB2 guy who is going to ask on the DB2 list about the DB2 portion of this question, but if anyone here has anything to contribute, I would appreciate it. We primarily run some Peoplesoft applications on this Lpar. We are running at 100% CPU busy on the DB2 lpar most of the time this week, whereas before the install of DB2 1.8 in compatibility mode, most of the time the CPU was not at 100%. Thanks in advance. Eric -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- 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
Re: Add Storage To Lpar - z/800
Did you define any storage as reserved in the activation profile? If so, yes, you can. If not, I don't know of any way. Note that it's not just a re-IPL you would need to do; you would need to redefine the activation profile with more storage and then reactivate the LPAR. Kevin McKenzie External Phone: 845-435-8282, Tie-line: 8-295-8282 z/OS BCP SVT, Dept FXKA, Bldg 706/2D38 Eric Bielefeld [EMAIL PROTECTED] Sent by: IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu 11/25/2008 12:11 PM Please respond to IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu To IBM-MAIN@bama.ua.edu cc Subject Add Storage To Lpar - z/800 Can real storage be added to an Lpar on a z/800 without shutting down the Lpar and re-IPLing? We have 4 Lpars defined, only two of them running now. Both Lpars have 3G of memory. I think the 2 Lpars that aren't running have .5G each. I know we have a little less than 1G that is free and unassigned, so I'm wondering if I can add that to our production DB2 lpar without having to IPL? We just installed DB2 V8 in compatiblity mode. Response time went from .5 seconds average to 1.2 seconds. No one has been complaining, but this is a week that many people have taken off, so volume is down. We have to get a handle on this by the end of tomorrow, as we are closed Thursday and Friday. We have a DB2 guy who is going to ask on the DB2 list about the DB2 portion of this question, but if anyone here has anything to contribute, I would appreciate it. We primarily run some Peoplesoft applications on this Lpar. We are running at 100% CPU busy on the DB2 lpar most of the time this week, whereas before the install of DB2 1.8 in compatibility mode, most of the time the CPU was not at 100%. Thanks in advance. Eric -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- 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 -- 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
Re: Add Storage To Lpar - z/800
IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu wrote on 11/25/2008 12:11:58 PM: Can real storage be added to an Lpar on a z/800 without shutting down the Lpar and re-IPLing? We have 4 Lpars defined, only two of them running now. Both Lpars have 3G of memory. I think the 2 Lpars that aren't running have .5G each. I know we have a little less than 1G that is free and unassigned, so I'm wondering if I can add that to our production DB2 lpar without having to IPL? You can add storage to a running MVS system, but only if the storage was defined to the LPAR zone as Reserved when MVS was IPLed. MVS needs to know at IPL time the total amount of storage that might ever be online, so that it can build an appropriately sized Page Frame Table. If D M=STOR does not show you any offline storage amounts, then you cannot bring more storage online without IPLing. Jim Mulder z/OS System Test IBM Corp. Poughkeepsie, NY -- 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
Re: Add Storage To Lpar - z/800
Looks the memory issue was already covered. For DB2 V8 did you REBIND all of your packages??? Regards Roland -- 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
Re: Add Storage To Lpar - z/800
Thanks to all that replied. I'll only reply to this answer to avoid cluttering up the list. I suspected that I probably couldn't add any storage to this Lpar without at least an IPL. Both of LP01 and LP02 have 2 GB defined for real storage, and 1GB in reserve. I believe the 1GB in reserve gets varied online just after the IPL, as both systems show 3072 MB in storage after a D M=STOR command. I did find out that HSA is 128M, and with LP03 LP04 being at 512M, I should have 896M available to add to LP02, which is our DB2 Lpar. I'm not sure if I can add that amount or not - I'll have to figure out what the increment size is. I'm sure we could easily remove 1 GB from LP01. It runs normally around 5-10% busy, unless I'm running SMP stuff or someone else is running batch. It also has zero paging, and no DB2. The transaction volumes are falling on that Lpar, and it will be phased out in the near future. Thanks for the quick replies. Eric Jim Mulder [EMAIL PROTECTED] wrote: IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu wrote on 11/25/2008 12:11:58 PM: Can real storage be added to an Lpar on a z/800 without shutting down the Lpar and re-IPLing? We have 4 Lpars defined, only two of them running now. Both Lpars have 3G of memory. I think the 2 Lpars that aren't running have .5G each. I know we have a little less than 1G that is free and unassigned, so I'm wondering if I can add that to our production DB2 lpar without having to IPL? You can add storage to a running MVS system, but only if the storage was defined to the LPAR zone as Reserved when MVS was IPLed. MVS needs to know at IPL time the total amount of storage that might ever be online, so that it can build an appropriately sized Page Frame Table. If D M=STOR does not show you any offline storage amounts, then you cannot bring more storage online without IPLing. Jim Mulder z/OS System Test IBM Corp. Poughkeepsie, NY -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- 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
Re: Add Storage To Lpar - z/800
I just talked to our DBA, and yes, we did REBIND all of our packages. I suspect we are now just over the knee of the curve - but the curve for what? Eric Roland Schiradin [EMAIL PROTECTED] wrote: Looks the memory issue was already covered. For DB2 V8 did you REBIND all of your packages??? Regards Roland -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- 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
Re: Add Storage To Lpar - z/800
Standard plea to customers: Find out how much memory you actually have on each machine and ensure you deploy the right portions of that as reserved to the right LPARs. (This is not the only situation this quarter where a customer was forced to IPL to add memory out of idle to an LPAR.) And standard plea to Development (which I WILL take forward if I can): Have RMF able to report the installed memory so customers can figure out what they've got idle. (Also that installed but not purchased would be good.) And, no, it's not there right now. But, on z10 having the HSA a standard 16GB was a good idea - or at least so it seems so far. So customers don't have to ask for an API to report HSA size via RMF. (But we could still use one.) Martin Martin Packer Performance Consultant IBM United Kingdom Ltd +44-20-8832-5167 +44-7802-245-584 [EMAIL PROTECTED] Eric Bielefeld wrote: Thanks to all that replied. I'll only reply to this answer to avoid cluttering up the list. I suspected that I probably couldn't add any storage to this Lpar without at least an IPL. Both of LP01 and LP02 have 2 GB defined for real storage, and 1GB in reserve. I believe the 1GB in reserve gets varied online just after the IPL, as both systems show 3072 MB in storage after a D M=STOR command. I did find out that HSA is 128M, and with LP03 LP04 being at 512M, I should have 896M available to add to LP02, which is our DB2 Lpar. I'm not sure if I can add that amount or not - I'll have to figure out what the increment size is. I'm sure we could easily remove 1 GB from LP01. It runs normally around 5-10% busy, unless I'm running SMP stuff or someone else is running batch. It also has zero paging, and no DB2. The transaction volumes are falling on that Lpar, and it will be phased out in the near future. Thanks for the quick replies. Eric 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: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Add Storage To Lpar - z/800
Hopefully you get what storage you need contiguous or it's not just an IPL anymore..I got bit by this just last week. --- On Tue, 11/25/08, Eric Bielefeld [EMAIL PROTECTED] wrote: From: Eric Bielefeld [EMAIL PROTECTED] Subject: Re: Add Storage To Lpar - z/800 To: IBM-MAIN@bama.ua.edu Date: Tuesday, November 25, 2008, 6:58 PM Thanks to all that replied. I'll only reply to this answer to avoid cluttering up the list. I suspected that I probably couldn't add any storage to this Lpar without at least an IPL. Both of LP01 and LP02 have 2 GB defined for real storage, and 1GB in reserve. I believe the 1GB in reserve gets varied online just after the IPL, as both systems show 3072 MB in storage after a D M=STOR command. I did find out that HSA is 128M, and with LP03 LP04 being at 512M, I should have 896M available to add to LP02, which is our DB2 Lpar. I'm not sure if I can add that amount or not - I'll have to figure out what the increment size is. I'm sure we could easily remove 1 GB from LP01. It runs normally around 5-10% busy, unless I'm running SMP stuff or someone else is running batch. It also has zero paging, and no DB2. The transaction volumes are falling on that Lpar, and it will be phased out in the near future. Thanks for the quick replies. Eric Jim Mulder [EMAIL PROTECTED] wrote: IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu wrote on 11/25/2008 12:11:58 PM: Can real storage be added to an Lpar on a z/800 without shutting down the Lpar and re-IPLing? We have 4 Lpars defined, only two of them running now. Both Lpars have 3G of memory. I think the 2 Lpars that aren't running have .5G each. I know we have a little less than 1G that is free and unassigned, so I'm wondering if I can add that to our production DB2 lpar without having to IPL? You can add storage to a running MVS system, but only if the storage was defined to the LPAR zone as Reserved when MVS was IPLed. MVS needs to know at IPL time the total amount of storage that might ever be online, so that it can build an appropriately sized Page Frame Table. If D M=STOR does not show you any offline storage amounts, then you cannot bring more storage online without IPLing. Jim Mulder z/OS System Test IBM Corp. Poughkeepsie, NY -- Eric Bielefeld Systems Programmer Washington University St Louis, Missouri 314-935-3418 -- 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 -- 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
Re: Add Storage To Lpar - z/800
In a message dated 11/25/2008 2:30:08 P.M. Central Standard Time, [EMAIL PROTECTED] writes: knee of the curve - but the curve for what? DB/2 lives in Buffer pool city. The first bottle neck is underallocated pools. Lots of tuning opportunities. Craig Mullin's(formerly with Platinum) book is a good starting point. The CA Platinum tools gave us the best feedback for systems and DBA's. **One site has it all. Your email accounts, your social networks, and the things you love. Try the new AOL.com today!(http://pr.atwola.com/promoclk/10075x1212962939x1200825291/aol?redir=http://www.aol.com/?optin=new-dp %26icid=aolcom40vanity%26ncid=emlcntaolcom0001) -- 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
