regarding RAM size and db parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sandeep.iitk@gmail.com - 26 Sep 2008 17:13 GMT

Hi All,
Just want to confirm, for a given RAM size on a server, if we increase
the sheapthresh, we have to decrease bufferpool size (keeping other
parameters same)? Please make it clear , i am new to db2. Thanks in
advance

Reply to this Message

Liam Finnie - 26 Sep 2008 18:28 GMT

On Sep 26, 12:13 pm, "sandeep.i...@gmail.com" <sandeep.i...@gmail.com>
wrote:

> Hi All,
> Just want to confirm, for a given RAM size on a server, if we increase
> the sheapthresh, we have to decrease bufferpool size (keeping other
> parameters same)? Please make it clear , i am new to db2. Thanks in
> advance

Hi Sandeep,

You're correct that if you don't have excess free RAM, if you increase
the size of one memory area, you'll need to decrease another to avoid
paging.

If you are using DB2 9 or later, you might want to consider using STMM
(Self-Tuning Memory Manager). STMM can distribute memory among the
major DB2 memory consumers automatically, according to which consumer
has the highest need. DB2 9.5 should make DB2 memory configuration
even easier.

Cheers,
Liam.

Reply to this Message