query_heap_sz error??? on v 5.2

[truu...@ca.ibm.com]

Michael Mel wrote:
>
> My questions are:
> 1. Is query heap allocated as a shared pool of memory for all connections or
> for each connection.
> 2. Is there a way to monitor this parameter? I haven't found one using
> either DB2 tools or NT performance monitor.
> 3. Any idea what might cause this to occur (i.e. some particularly complex
> query or ???)
> 4. What should I do about it?
>

A quick read about this parameter in the Administration Guide tells me
it's per connection (private memory for an agent), it's not all
allocated up-front (i.e. it's a maximum) and what actually gets
allocated is quite dependent on row size (the input and output SQLDAs,
among other things, sit in this memory). So, for example, a big LOB
could sink you. I haven't found any monitor fields that report on
consumption of this memory, unfortunately, but I'm no monitor expert.
There doesn't seem to be any harm in increasing it.

Hope this helps,
--

Kaarel Truuvert
DB2 UDB Development