Thanks for your reply

Working on db2 8.2 installed on linux.

[[Email Address Removed] db2inst1]$ db2 get db cfg | grep STMTHEAP

SQL statement heap (4KB) (STMTHEAP) = 2048

[[Email Address Removed] db2inst1]$ db2 get db cfg | grep SORTHEAP

Sort list heap (4KB) (SORTHEAP) = 256

When i refresh my MQT's its taking a long time of around 30 mins. No idea
why its taking so long. The tables that are used have around 1.5 lac record.
I have the same table in two databases. Whereas in the other database its
taking only 10 mins.

I ran the command in both the databases and i get the same output for
STMTHEAP and SORTHEAP

Any suggestions

Thanks
Prem.



----- Original Message -----
From: "divakar" <db2udbdba-ezmlmshield-x44562030.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, July 30, 2005 12:19 AM
Subject: RE: Heap sort


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