Re: more RAM for DB2
If your DB2 uses VM Dataspaces, it will profit of tyhe extra storage your z/VM system has, but, you may have to check DB2's TARGETWS parameter, this can limit the storage DB2 can occupy, simplified: if DB2 finds out it has more pages resident than that number, it will tell CP to get rid of some of its pages. 2009/9/1 Graves Nora E nora.e.gra...@irs.gov 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 -- Kris Buelens, IBM Belgium, VM customer support
Re: more RAM for DB2
Thanks! We do use VM Dataspaces, but the TARGETWS parameter does need to be updated. Nora Graves From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Kris Buelens Sent: Tuesday, September 01, 2009 1:00 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: more RAM for DB2 If your DB2 uses VM Dataspaces, it will profit of tyhe extra storage your z/VM system has, but, you may have to check DB2's TARGETWS parameter, this can limit the storage DB2 can occupy, simplified: if DB2 finds out it has more pages resident than that number, it will tell CP to get rid of some of its pages. 2009/9/1 Graves Nora E nora.e.gra...@irs.gov 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 -- Kris Buelens, IBM Belgium, VM customer support
Re: more RAM for DB2
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