Re: more RAM for DB2

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

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 numbe

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