Re: Heap size problem

Re: Heap size problem

 

  

Hi there,

Just as a hint... If you type into db2 command line (clp):
db2 => ? SQL0973N
you will see the answer for your question (which is basically the same as the other users' responses).

This works for all error codes ;)

Regards,
Frank

A Prabhakar Rao wrote:
> Hi DBA's
>
> I am facing following problem while executing some queries from our application.
>
> Trace: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0973N Not enough storage is available in the "APPGROUP_SHARE_HEAP" heap to process the statement. SQLSTATE=57011
>
>
> Can any one help me how to solve this problem...What are the exact DB parameters to be tuned here and on what basis.
>
>
> Thanks & Regards
> Prabhakar
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>

DB2 & UDB email list listserv db2-l LazyDBA home page