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