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
