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

SQL0954C -- Not enough storage is available in the application heap to process the statement.

P: n/a
Raj
Hi all,
I recieve this error message SQL0954C when i execute an SQL, it is
failry complex ... i've seen more complex sql's running with out any
error. We are on partitioned database with intraparallelism should i
increase the Appheapsz or app_ctrl_heap_sz??
------------------------------------------------------------------------------------------
SQL0954C Not enough storage is available in the application heap
to process the statement.
Explanation:
All available memory for the application has been used.
The statement cannot be processed.
User Response:
Terminate the application on receipt of this message. Increase
the database configuration parameter ( applheapsz ) to allow a
larger application heap.
sqlcode : -954
------------------------------------------------------------------------------------------
Thanks,
Raj

Apr 18 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Look into your db2diag.log for the coordinator node. I suspect that it is
the one issuing the message.
This message "can mean" that the work area used by the agent to compile the
statement is not large enough because the stement is too coplex.
As mentionned, it is the applheapsz that needs to be increased as it is used
by the agent. appl_ctrl_heap_sz is a shared area in ESE that is used by
subagents in each partition to communicate with each other.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Raj" <sp****@yahoo.com> a écrit dans le message de news:
11*********************@g10g2000cwb.googlegroups.c om...
Hi all,
I recieve this error message SQL0954C when i execute an SQL, it is
failry complex ... i've seen more complex sql's running with out any
error. We are on partitioned database with intraparallelism should i
increase the Appheapsz or app_ctrl_heap_sz??
------------------------------------------------------------------------------------------
SQL0954C Not enough storage is available in the application heap
to process the statement.
Explanation:
All available memory for the application has been used.
The statement cannot be processed.
User Response:
Terminate the application on receipt of this message. Increase
the database configuration parameter ( applheapsz ) to allow a
larger application heap.
sqlcode : -954
------------------------------------------------------------------------------------------
Thanks,
Raj


Apr 19 '06 #2

P: n/a
Raj
Thanks a lot ...

Apr 19 '06 #3

P: n/a
Raj wrote:
Hi all,
I recieve this error message SQL0954C when i execute an SQL, it is
failry complex ... i've seen more complex sql's running with out any
error. We are on partitioned database with intraparallelism should i
increase the Appheapsz or app_ctrl_heap_sz??
------------------------------------------------------------------------------------------ SQL0954C Not enough storage is available in the application heap
to process the statement.
Explanation:
All available memory for the application has been used.
The statement cannot be processed.
User Response:
Terminate the application on receipt of this message. Increase
the database configuration parameter ( applheapsz ) to allow a
larger application heap.
sqlcode : -954

------------------------------------------------------------------------------------------

The message says to increase the applheapsz. So I would try that.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 19 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.