Re: SVC Dumps and DB2
Lizett Koehler wrote on 08/08/2006 04:02:23 PM: > Will look at Compressed to see if it could provide any releif. We have a large inventory of compressed dumps in Poughkeepsie, and our experience suggests that you'll save around 40% of the space that you'd use without compression. Bob Wright - MVS Service Aids -- 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: SVC Dumps and DB2
Thanks Sam, and everyone else. We have no issue with the DASD part of the dump. I have that setup as stripped. It is just the virtual dump I am having difficutly with. We have limited storage and so our MAXSPACE can only go to about 4.5G. The 6G or 8G is out of the question right now. I was just hoping that the powers that be would allow a customer to customize what in DB2 would need to be dumped. With the number of threads, SP, and trans going on, we always run out of MAXSPACE during any DB2 SVC Dump process. Will look at Compressed to see if it could provide any releif. Lizette -- 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: SVC Dumps and DB2
Hi Lizette, You didn't say COMPRESSED so if you are not you might try it. It takes a little CPU but is well worth it give the size reduction for a typical SVC dump. As an aside I think IBM plans some day to make some of the enhancements to SVC dump that have already been incorporated in Stand Alone dump to reduce the size and then it might be less effective but for now it is quite an impressive reduction. We already use MAXSPACE=8000M on our large LPARs (32M) I expect I will have to increase that again at some point. The consideration for us is to have enough frames on the available frame queue and a robust paging configuration to handle the demand from large dumps or other spikes in memory use. It has been said before but if you come up short and the processor model you have supports it fight like anything to get them to buy memory. At $10K/GIG or $8K/GIG on z9 it is the cheapest thing you can buy to improve performance. Best Regards, Sam Knutson, GEICO Performance and Availability Management mailto:[EMAIL PROTECTED] (office) 301.986.3574 "Think big, act bold, start simple, grow fast..." -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Lizette Koehler Sent: Thursday, August 03, 2006 8:31 AM To: IBM-MAIN@BAMA.UA.EDU Subject: SVC Dumps and DB2 Does anyone know if there is a way to reduce the amount of information DB2 feels it needs to dump when it requests an SVC Dump? We had MAXSPACE set at 4500M and it still was not enough. I do have the Dump Data sets SMS managed and STRIPPED (extended format) so that part should not be a problem. Or is there a way to calculate how much MAXSPACE will be needed by DB2? Lizette This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- 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: SVC Dumps and DB2
Lizette, DASD-wise, not sure if you've looked already, but the DB2 V8 Installation Guide has dump data set size storage requirements in Chapter 2. IBM support notes that "... summary data in dumps is usually enough to diagnose most problems". Lock Lyon Compuware Corp Lizette Koehler <[EMAIL PROTECTED]> Sent by: IBM Mainframe Discussion List 08/03/2006 08:31 AM Please respond to IBM Mainframe Discussion List To IBM-MAIN@BAMA.UA.EDU cc Subject SVC Dumps and DB2 Does anyone know if there is a way to reduce the amount of information DB2 feels it needs to dump when it requests an SVC Dump? We had MAXSPACE set at 4500M and it still was not enough. I do have the Dump Data sets SMS managed and STRIPPED (extended format) so that part should not be a problem. Or is there a way to calculate how much MAXSPACE will be needed by DB2? Lizette -- 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: SVC Dumps and DB2
We use 6000M without any issues. Thanks. John Eatherly Or is there a way to calculate how much MAXSPACE will be needed by DB2? -- 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