To view:

Db2 get db cfg for <dbname> | grep STMTHEAP


To modify:

Db2 update db cfg for <dbname> using STMTHEAP <value>






-Terrence

-----Original Message-----
From: PremnathJ
[mailto:oracledba-ezmlmshield-x62989006.[Email address protected]
Sent: Tuesday, July 29, 2003 11:40 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.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page