Memory Usage

[db2udbdba]

Hi Guys

Can Anyone explain me How db2 utilizes the memory ?

for the applications/agents

Thanks in advance

 

[gregsimpson]

Each DB2 application has an associated DB2 coordinating agent. The database agent accesses the db resource for the application. There are tuning params for each resource which use the database agent. The Agents private memory exists for each agent. Its size is determined by the values of the following params

Agent stack size -agent_stack_sz
Application heap size - applheapsz
Sort heap size - sortheap
Statement heap size - stat_heap_sz
Query heap size - Query_heap_sz

as well as others which I can't remember off the top of my head.

Cheers
Greg