Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
It seems that our problem was on Jerry Ng's hot topic list at SHARE last week. IBM have supplied a temporary fix which seems to have solved the problem. On Fri, Aug 6, 2010 at 4:30 PM, Scott Rowe scott.r...@joann.com wrote: YMMV, DB2 version upgrades take far longer than z/OS releases. I can go from ServerPac order to production in a few months, but a new DB2 version typically takes 9-12 months. I have only 4 LPARs total, but there are about 20 DB2 subsystems (5 production). Joel C. Ewing jcew...@acm.org 8/6/2010 9:20 AM On 08/05/2010 08:27 PM, Shane wrote: I would have thought DB2 might be a more pressing issue for a business. Shane ... On Thu, 2010-08-05 at 23:42 +0300, Mike Shorkend wrote: z/os 1.9 is going out of service in September IIRC. We have to migrate to z/os 1.11 before then. The LPAR has 4.5 GB DB2 V8 z/OS 1.9 EoS is 2010-09, and in our experience it takes a minimum of 4 months to adequately check out all the major subsystems and vendor products under a new z/OS version before a move to production even in a single-production-LPAR environment. I once did it in less by working 60+ hour weeks for over a month when the new z/OS was a coreq for a firmly scheduled hardware upgrade, but I wouldn't recommend it. DB2 V8 EoS is 2012-04-30, light years away by comparison, and I've seen DB2 upgrades phased into production in less than 2 months. Unless there is some new DB2 feature essential to your shop, cost is often a significant motivator for staying with older versions as long as they are still supported. -- Joel C. Ewing, Fort Smith, ARjcew...@acm.org -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- Mike Shorkend m...@shorkend.com www.shorkend.com Tel: +972524208743 Fax: +97239772196 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On Mon, 9 Aug 2010 22:43:50 +0300, Mike Shorkend mike.shork...@gmail.com wrote: It seems that our problem was on Jerry Ng's hot topic list at SHARE last week. IBM have supplied a temporary fix which seems to have solved the problem. Mike - Was it in PTF or local fix form? The APAR has not been updated with any new information. Thanks, Pat Lyon -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
Pat It is not an official PTF yet. Mike On Mon, Aug 9, 2010 at 11:40 PM, Patrick Lyon ptl...@midamerican.comwrote: On Mon, 9 Aug 2010 22:43:50 +0300, Mike Shorkend mike.shork...@gmail.com wrote: It seems that our problem was on Jerry Ng's hot topic list at SHARE last week. IBM have supplied a temporary fix which seems to have solved the problem. Mike - Was it in PTF or local fix form? The APAR has not been updated with any new information. Thanks, Pat Lyon -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- Mike Shorkend m...@shorkend.com www.shorkend.com Tel: +972524208743 Fax: +97239772196 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On Fri, 6 Aug 2010 02:45:37 +, Ted MacNEIL eamacn...@yahoo.ca wrote: An increase of HSA could keep you from activating an LPAR, but that's all. Since they are now independent, why? To be more clear: could have. Before, HSA counted in customer total storage. But my point was that HSA never could have been the problem even on older processors (unless the box was in basic mode). Mark -- Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS mailto:mzel...@flash.net Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html Systems Programming expert at http://expertanswercenter.techtarget.com/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On 08/05/2010 08:27 PM, Shane wrote: I would have thought DB2 might be a more pressing issue for a business. Shane ... On Thu, 2010-08-05 at 23:42 +0300, Mike Shorkend wrote: z/os 1.9 is going out of service in September IIRC. We have to migrate to z/os 1.11 before then. The LPAR has 4.5 GB DB2 V8 z/OS 1.9 EoS is 2010-09, and in our experience it takes a minimum of 4 months to adequately check out all the major subsystems and vendor products under a new z/OS version before a move to production even in a single-production-LPAR environment. I once did it in less by working 60+ hour weeks for over a month when the new z/OS was a coreq for a firmly scheduled hardware upgrade, but I wouldn't recommend it. DB2 V8 EoS is 2012-04-30, light years away by comparison, and I've seen DB2 upgrades phased into production in less than 2 months. Unless there is some new DB2 feature essential to your shop, cost is often a significant motivator for staying with older versions as long as they are still supported. -- Joel C. Ewing, Fort Smith, ARjcew...@acm.org -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
Hey Joel, yeah I realised after I sent it that was probably a senior moment. We've been chasing customers re DB2, but that would have been to get them off V7. D'oh. Shane ... On Fri, 2010-08-06 at 08:20 -0500, Joel C. Ewing wrote: DB2 V8 EoS is 2012-04-30, light years away by comparison, and I've seen DB2 upgrades phased into production in less than 2 months. Unless there is some new DB2 feature essential to your shop, cost is often a significant motivator for staying with older versions as long as they are still supported. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
YMMV, DB2 version upgrades take far longer than z/OS releases. I can go from ServerPac order to production in a few months, but a new DB2 version typically takes 9-12 months. I have only 4 LPARs total, but there are about 20 DB2 subsystems (5 production). Joel C. Ewing jcew...@acm.org 8/6/2010 9:20 AM On 08/05/2010 08:27 PM, Shane wrote: I would have thought DB2 might be a more pressing issue for a business. Shane ... On Thu, 2010-08-05 at 23:42 +0300, Mike Shorkend wrote: z/os 1.9 is going out of service in September IIRC. We have to migrate to z/os 1.11 before then. The LPAR has 4.5 GB DB2 V8 z/OS 1.9 EoS is 2010-09, and in our experience it takes a minimum of 4 months to adequately check out all the major subsystems and vendor products under a new z/OS version before a move to production even in a single-production-LPAR environment. I once did it in less by working 60+ hour weeks for over a month when the new z/OS was a coreq for a firmly scheduled hardware upgrade, but I wouldn't recommend it. DB2 V8 EoS is 2012-04-30, light years away by comparison, and I've seen DB2 upgrades phased into production in less than 2 months. Unless there is some new DB2 feature essential to your shop, cost is often a significant motivator for staying with older versions as long as they are still supported. -- Joel C. Ewing, Fort Smith, ARjcew...@acm.org -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains confidential and privileged information intended only for the addressee. If you are not the intended recipient, please be advised that you have received this material in error and that any forwarding, copying, printing, distribution, use or disclosure of the material is strictly prohibited. If you have received this material in error, please (i) do not read it, (ii) reply to the sender that you received the message in error, and (iii) erase or destroy the material. Emails are not secure and can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by email. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
Hi We migrated to z/os 1.11 on one of our production machines. Before the upgrade we had almost no paging. We now see quite a lot of paging from DB2. Any ideas ?? Thanks in advance Sheldon Davis -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
Larger HSA? What is your D M=STOR shows before after the change? ITschak On Thu, Aug 5, 2010 at 11:46 AM, Sheldon Davis sda...@isracard.co.ilwrote: Hi We migrated to z/os 1.11 on one of our production machines. Before the upgrade we had almost no paging. We now see quite a lot of paging from DB2. Any ideas ?? Thanks in advance Sheldon Davis -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu 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 lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On Thu, 5 Aug 2010 03:46:50 -0500, Sheldon Davis sda...@isracard.co.il wrote: We migrated to z/os 1.11 on one of our production machines. Before the upgrade we had almost no paging. We now see quite a lot of paging from DB2. Any ideas ?? Not really. Did anything else change that could have changed storage usage? Did you start specifying large pages (LFAREA) or enable any other new function that you might have not been using before? Are you sure you have the same amount of memory as you had prior to the upgrade available the LPAR? (don't laugh, I've seen problems like this) To start you might want to go back to some SMF data prior to z/OS 1.11 and compare the working set sizes of all your address spaces (type 30s) to see what might have changed. SORT REAL D in an SDSF DA and and RMF III STORF might also provide clues assuming you have an idea of what things looked like before z/OS 1.11. BTW, what release did you migrate from? Mark -- Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS mailto:mzel...@flash.net Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html Systems Programming expert at http://expertanswercenter.techtarget.com/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
Larger HSA? What is your D M=STOR shows before after the change? Isn't the HSA independent of user memory, now? - I'm a SuperHero with neither powers, nor motivation! Kimota! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On a Z10 it is Ted MacNEIL eamacn...@yahoo. CATo Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List ibm-m...@bama.ua Subject .edu Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space 08/05/2010 09:30 AM Please respond to IBM Mainframe Discussion List ibm-m...@bama.ua .edu Larger HSA? What is your D M=STOR shows before after the change? Isn't the HSA independent of user memory, now? - I'm a SuperHero with neither powers, nor motivation! Kimota! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu 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 lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
I work with the OP. We are migrating from z/OS 1.9 and it is indeed a z9, so HSA is still part of the customer's central storage. We have found an OPEN APAR OA33307 which describes our problem. Hopefully there will be a PTF soon as the End-of-Service date is approaching. Mike On Thu, Aug 5, 2010 at 6:46 PM, August Carideo august.cari...@avon.comwrote: On a Z10 it is Ted MacNEIL eamacn...@yahoo. CATo Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List ibm-m...@bama.ua Subject .edu Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space 08/05/2010 09:30 AM Please respond to IBM Mainframe Discussion List ibm-m...@bama.ua .edu Larger HSA? What is your D M=STOR shows before after the change? Isn't the HSA independent of user memory, now? - I'm a SuperHero with neither powers, nor motivation! Kimota! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu 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 lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- Mike Shorkend m...@shorkend.com www.shorkend.com Tel: +972524208743 Fax: +97239772196 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
z/os 1.9 is going out of service in September IIRC. We have to migrate to z/os 1.11 before then. The LPAR has 4.5 GB DB2 V8 On Thu, Aug 5, 2010 at 11:25 PM, Bob Rutledge deerh...@ix.netcom.comwrote: Mike Shorkend wrote: I work with the OP. We are migrating from z/OS 1.9 and it is indeed a z9, so HSA is still part of the customer's central storage. We have found an OPEN APAR OA33307 which describes our problem. Hopefully there will be a PTF soon as the End-of-Service date is approaching. End of service for what? That APAR is for z/OS 1.11 which shouldn't go out of service for a tad more than 2 years. If you don't mind, what version of DB2 and how much real memory does the LPAR have? I ask because I'm going to care in the near future (DB2 V8 running in a 4G LPAR). Mike Bob -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- Mike Shorkend m...@shorkend.com www.shorkend.com Tel: +972524208743 Fax: +97239772196 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
Mike Shorkend wrote: I work with the OP. We are migrating from z/OS 1.9 and it is indeed a z9, so HSA is still part of the customer's central storage. We have found an OPEN APAR OA33307 which describes our problem. Hopefully there will be a PTF soon as the End-of-Service date is approaching. End of service for what? That APAR is for z/OS 1.11 which shouldn't go out of service for a tad more than 2 years. If you don't mind, what version of DB2 and how much real memory does the LPAR have? I ask because I'm going to care in the near future (DB2 V8 running in a 4G LPAR). Mike Bob -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On a Z10 it is That's what I thought. So, an increase in HSA would be irrelevent to paging. - I'm a SuperHero with neither powers, nor motivation! Kimota! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
I would have thought DB2 might be a more pressing issue for a business. Shane ... On Thu, 2010-08-05 at 23:42 +0300, Mike Shorkend wrote: z/os 1.9 is going out of service in September IIRC. We have to migrate to z/os 1.11 before then. The LPAR has 4.5 GB DB2 V8 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
On Thu, 5 Aug 2010 22:23:16 +, Ted MacNEIL eamacn...@yahoo.ca wrote: On a Z10 it is That's what I thought. So, an increase in HSA would be irrelevent to paging. It's irrelevant for any box not running in basic mode (which hasn't even been available for a long time). If you are in LPAR mode, the amount of storage available to the LPAR doesn't change once the LPAR is activated from the image profile. An increase of HSA could keep you from activating an LPAR, but that's all. Mark -- Mark Zelden - Zelden Consulting Services - z/OS, OS/390 and MVS mailto:mzel...@flash.net Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html Systems Programming expert at http://expertanswercenter.techtarget.com/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Migration to z/os 1.11 causes Paging in DB2 DBM1 address space
An increase of HSA could keep you from activating an LPAR, but that's all. Since they are now independent, why? - I'm a SuperHero with neither powers, nor motivation! Kimota! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html