Heap size problem

Heap size problem

 

  

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

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