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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj - 18 Apr 2006 20:52 GMT

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

Reply to this Message

Pierre Saint-Jacques - 19 Apr 2006 02:57 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Hi all,
> I recieve this error message SQL0954C when i execute an SQL, it is
[quoted text clipped - 15 lines]
> Thanks,
> Raj

Reply to this Message

Raj - 19 Apr 2006 03:51 GMT

Thanks a lot ...

Reply to this Message

Knut Stolze - 19 Apr 2006 09:35 GMT

> 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.
[quoted text clipped - 6 lines]
> larger application heap.
> sqlcode : -954

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

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

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message