I don't know (and haven't had a chance to review the APAR Barbara mentioned), but since the vast majority of the storage that DB2 uses above the bar is for Bufferpools, the EDM pool and other pools whose sizes is set by the user, via DB2 commands and customization, the only way that DB2 SHOULD cause a problem would be if the DB2 systems programmer (or sysadm) incorrectly sizes these pools. However, I do agree that DB2 should play by the rules and not override a system limit. Instead it should come down (probably with an S04F abend code and a documented reason code). Wayne Driscoll Product Developer Western Metal Supply NOTE: All opinions are strictly my own.
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Mark Zelden Sent: Friday, October 28, 2005 9:30 AM To: [email protected] Subject: Re: MEMLIMIT and IEFUSI On Thu, 27 Oct 2005 00:00:00 GMT, Ted MacNEIL <[EMAIL PROTECTED]> wrote: >>The number eventually gets stored into an MVS control block which is examined >by various system services. >... > >I don't think you want to touch DB2 V8+ as far as MEMLIMIT is concerned. >It is architected (and expects) to use all that memory. >Only a couple of pools are left below the bar. >You would kick the snot out of any performance gains that this gives >you, if it would even come up. >-teD Surely you jest! What don't you (and IBM) get?! If DB2 were to "use all that memory" I would need a large portion of my entire DASD farm dedicated to page data sets. Isn't the max real supported by z/OS still 128G? What's the point of hard coding 4T? For as long as I can remember IBM has told us to protect ourselves from wait03C with IEFUSI (and a robust paging subsystem). It hasn't really mattered in the recent past with large systems and 31-bit, but now it is more important than ever. I can no longer rely on a robust paging system alone to protect the system. I just don't get it..... Vendors.... PLEASE..... If you are going to need oodles of storage above the bar, just document your requirements just like you would for common storage. Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America and Farmers Insurance Group mailto: [EMAIL PROTECTED] Systems Programming expert at http://Search390.com/ateExperts/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.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 ---------------------------------------------------------------------- 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
