DB2 MEMLIMIT for DBM1 is 4TB - according to SMF 30 (and John Campbell). Cheers, Martin
Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: "nitz-...@gmx.net" <nitz-...@gmx.net> To: IBM-MAIN@LISTSERV.UA.EDU Date: 30/10/2014 06:40 Subject: Re: AW: Re: MEMLIMIT not honoured by DB2 utility job Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> Peter, > I have found plenty of places where the discussion is about DB2's DBM1 and IRLM address spaces. Those ignore any MEMLIMIT setting and set this limit to values defined in DB2. > > I could not find anything related to the utility program DSNX9WLM regarding MEMLIMIT. Waiting for an answer from my DB2 colleagues. I don't think that this is written down anywhere. All you need to do is dump the running job and check the value of memlimit in the RSM control block (I believe it was an RSM control block). You'll find that DB2 overwrites whatever the installation specifies with what DB2 wants by the simple expedient of being APF authorized. They just go and put their own value into the RSM control block, effectively overwriting usual controls. Check the archives, I seem to have a dim memory that we discussed this here and I got bashed when I objected to such a practise. In my case it was GRS (they do the same), I think, back in z/OS 1.2 or 1.4 days. Just look at the memlimit column in SDSF DA, you'll see exactly which address spaces have adopted this practise. (In our case, it was even more evident, because I had limited *everybody* to 6GB MEMLIMIT in IEFUSI/SMF, for the simple reason that the system didn't have enough real storage to back any more. Barbara ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu 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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN