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.

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