Steve, I assume that Lizette's question has to do with DB2 V8 and defining DB2 bufferpools large enough to hold most of the data in the DBM1 above the bar private storage, so it will still be "DB2." As for doing this, the big question is "how much real memory do you have on your machine?" Making the bufferpools huge without having storage to back it could drive paging rates through the roof. This also may (will?) require additional paging space available. Running out of available real pages and or aux slots will cause response time to drop like a rock (like the time it takes to IPL). Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Steve Comstock Sent: Thursday, June 14, 2007 2:06 PM To: [email protected] Subject: Re: DB2 Data Bases and Central Storage
Lizette Koehler wrote: > Hi - > > Has anyone been asked by their DB2 DBAs (or DB2 Sysprogs) on the MVS > Mainframe what it would take to place their Tables into Storage? > We are DB2 V8 nfm with z/OS V1.7 on a z9 and z860 systems. > <snip> Actually, I've given some thought to this in the past. The biggest drawback I've decided is this: once your tables are in memory, they are no longer DB2. That is, you are not able to use SQL for queries or updates to tables stored in virtual. <snip> > Lizette > (making bad code run faster...) [Love it!] Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques ---------------------------------------------------------------------- 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
