SQL0973N QUERY_HEAP_SZ to small

[Ralf]

Hello,

I get the following message:

SQL0973N Der verfügbare Bereich im Zwischenspeicher "QUERY_HEAP"
reicht für die Ausführung der Anweisung nicht aus

when I send a select-statement to the database. The table has three
CLOB-Fields. But I get the message not until at first select, but after
4 or 5 selects at tables with CLOBs. I have startet the DBManager with
defaults for aslheapsz and query_heap_sz, I get the message, then I
have increased the values to 1000 and 5000, but I get the message, only
later. Can anybody help me please.

Best Regards

Ralf

[indika]

Ralf wrote:

Hello,

I get the following message:

SQL0973N Der verfügbare Bereich im Zwischenspeicher "QUERY_HEAP"
reicht für die Ausführung der Anweisung nicht aus

when I send a select-statement to the database. The table has three
CLOB-Fields. But I get the message not until at first select, but after
4 or 5 selects at tables with CLOBs. I have startet the DBManager with
defaults for aslheapsz and query_heap_sz, I get the message, then I
have increased the values to 1000 and 5000, but I get the message, only
later. Can anybody help me please.

Best Regards

Ralf

Hi Ralf,

which system unix or windows?
how big are your clobs and how big is the size of every file you insert?
how big is your memory usage?

plz give us more info.

thanks,

indika