The statement heap has nothing to do with query execution.
This heap is needed to compile a query.
If it is too low you may get a -101 (Statement to long or too complex) or a
+437 warning
(query may perform suboptimal because the optimizer ran out of space)
during compilation of a query.

Cheers
Serge

"ighiurea " <db2udbdba-ezmlmshield-x96314401.[Email address protected] wrote
on 07/30/2005 10:46:42 AM:

> I have another question related to stmpheap and sortheap values...I
> increased the value for stmpheap to 16384(4k pages)=64MB buty ther users
> are still complainig about geetting the erros/waring and the long
> queries are failing ...how mauch shlud I increase the sortheap values or
> shoud I continue increasuing the stmpheap......
>
>
>
> thanks,
>
> >Which platform are you on.
> >
> >With Unix/AIX, you can see the values by using command :
> >
> > db2 get db cfg | grep STMTHEAP
> >db2 get db cfg | grep SORTHEAP
> >
> >To update values, use command:
> >
> > db2 update db cfg using STMTHEAP <value>
> >db2 update db cfg using SORTHEAP <value>
> >
> >
> >
> >
> >
> >Divakar
> >
> >
> >-----Original Message-----
> >From: PremnathJ
> >[mailto:db2udbdba-ezmlmshield-x86475952.[Email address protected]
> >
> >Sent: Wednesday, July 30, 2003 12:10 AM
> >To: LazyDBA Discussion
> >Subject: Heap sort
> >
> >dba's can someone help me how to view the heap sort size in db2 and
> >increase its size.
> >
> >
> >I need to increase the stmtheap size also.
> >
> >
> >How can this be done?
> >
> >Thanks
> >Prem.
> >
> >
> >---------------------------------------------------------------------
> >PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> >website: http://www.LazyDBA.com
> >To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> >
> >Confidentiality Notice
> >
> >
> >The information contained in this electronic message and any
> attachments to this message are intended
> >for the exclusive use of the addressee(s) and may contain
> confidential or privileged information. If
> >you are not the intended recipient, please notify the sender at
> Wipro or [Email address protected] immediately
> >and destroy all copies of this message and any attachments.
> >
> >
> >---------------------------------------------------------------------
> >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