I am unable to find this parameter APPGROUP_SHARE_HEAP....Or I have to
modify APPGROUP_MEM_SZ parameter?

----- Original Message -----
From: "Serge Rielau "
<db2udbdba-ezmlmshield-x79940580.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, September 30, 2005 3:40 PM
Subject: Re: Heap size problem


> Did you try increasing the APPGROUP_SHARE_HEAP....?
>
> Cheers
> Serge
>
>
>
>
> "A Prabhakar Rao "
> <db2udbdba-ezmlmshield-x10546398.[Email address protected] wrote on
> 09/30/2005 01:45:17 AM:
>
> > 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
> >
>
>
>
> ---------------------------------------------------------------------
> 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