regarding RAM size and db parameter

[sandeep.iitk@gmail.com]

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

[Liam Finnie]

Re: regarding RAM size and db parameter

On Sep 26, 12:13 pm, "sandeep.i...@g mail.com" <sandeep.i...@g mail.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.