By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

SQL0973N QUERY_HEAP_SZ to small

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.