Hi Friends,

Is bufferpool created only in Real memory or can it be also created in virtual memory ?

Thanks,
panditt

DB2 is the real thing, and therefore only uses real memory. If you don't have enough real memory (or are allocating too much memory for DB2), you are likely to encounter some very serious problems with DB2, including possible instance crash.

To be precise, in any modern operating system all memory is virtual. In theory you could create a bufferpool that exceeds the amount of available real memory, but that would be like shooting yourself in the foot with a Gatling gun, as Marcus mentioned.

Is bufferpool pinned in real memory or can it be paged out?

As far as I know, db shared memory (including bufferpools) is only pinned on Solaris. There is a registry variable that will allow you to pin it on other Unix/Linux platforms. Please take a look at db2_pinned_bp if you're interested. Note that this registry variable will not just pin the bufferpools but the entire db shared memory set.

Thanks a lot friends !!! Thanks for all the explanation. My question is answered.


Thanks
Panditt