If you read DB2 Performance Guide (available online for free download - Link available in Useful DB2 Stuff thread), there is a topic 'How DB2 uses memory?' ... That should give you a fair idea ....
Anyway, I don't think you can get a definitive figure ...
This is something I remember vaguley ... Can anyone confirm :
DB2 initially allocates the minimum amount of memory required for the process, but later on when running an application, it allocates more memory as required... On finishing its job, it never releases them back but retains assuming it will need again therby avoiding the cost of releasing and acquiring resources ... If you have a memory constrained system, you will see that db2 processes at somepoint grab 'all' available memory and restart will be the only option available ...
There is a db2set variable to get around this, but don't have it on top of my head now
Originally posted by mcdb2
Thanks for giving me this info.
Could someone give any idea how to find out the memory requirements for each connection.
db2 VER is 7.2 on LINUX 7.2.0.
Thanks in advance,
Last edited by sathyaram_s; 09-24-03 at 17:34.
Visit the new-look IDUG Website , register to gain access to the excellent content.