Interestingly, I know of at least 1 customer for whom sticking the whole of their main DB2 table in memory ISN'T an option - even with the biggest (10TB) z13. I'm jolly sure they're not alone.
And I suspect this will persist for a VERY long time. Absolutely not against Data In Memory. Far from it, by the way. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Cloud & Systems Performance, 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: Ed Jaffe <edja...@phoenixsoftware.com> To: IBM-MAIN@LISTSERV.UA.EDU Date: 09/03/2016 16:12 Subject: Re: Does everybody use chargeback? Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On 3/8/2016 9:59 PM, Jesse 1 Robinson wrote: > -- A data base application was redesigned at the last minute to read the entire data base into memory at startup. The business unit noticed that they were charged for I/O but not for memory use. It was cheaper to occupy virtual storage than to perform reads. So much for common sense. They were obviously ahead of their time! These days, memory-mapped files are highly encouraged as one way to utilize that "free" memory everyone is getting on their z13! -- Edward E Jaffe Phoenix Software International, Inc 831 Parkview Drive North El Segundo, CA 90245 http://www.phoenixsoftware.com/ ---------------------------------------------------------------------- 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