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
>
>
>
>



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