Hello Graves, you should only concern with 2 buffer settings: NPAGBUF and NDIRBUF. Especially the NPAGBUF - the more the merrier. DB2 only works on data in its buffers. It will move data from DASD when it does not find what it is looking for in the buffers. So, the more buffer allocated, the better. It may put a drain in the CP's PAGING system if you specify too much. So, work with your SYSPROG to find the balance point. BTW, if you are using VMDSS, please check INFO APAR PK73730. Good luck. ...Roland
--- On Tue, 9/1/09, Graves Nora E <nora.e.gra...@irs.gov> wrote: From: Graves Nora E <nora.e.gra...@irs.gov> Subject: more RAM for DB2 To: IBMVM@LISTSERV.UARK.EDU Received: Tuesday, September 1, 2009, 3:31 PM Cross-posted to VM/ESA and DB2 lists. I'm running DB2 7.5 under z/VM 5.4 (both are the current releases). We have a brand-new z10 processor. My Systems Programmer has offered me 1 Gig of RAM, up from our current Virtual Storage of 384 Meg for the production database. I'd like to take advantage of this extra RAM, if at all possible. I've been using the Diagnosis Guide to see how to alleviate the problems of not enough storage, thinking that I can work backwards from that. I can see that I've got constraints on my current use of buffers per user, and I can increase that number. I'd like suggestions on other parameters to research, as well. TIA, Nora Graves
