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 - 30 May 2005 14:25 GMT
> Hello,
>
[quoted text clipped - 13 lines]
>
> 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