more RAM for DB2

2009-09-01 Thread Graves Nora E
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

Re: more RAM for DB2

2009-09-01 Thread Kris Buelens
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

Re: more RAM for DB2

2009-09-01 Thread Graves Nora E
@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

Re: more RAM for DB2

2009-09-01 Thread Roland P. Chung
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