Dan, how does it make the adjustment ? Based on the set SHEAPTHRES (20000)
value or default value for sort heap ?






"DANIEL CALLAHAN "
<db2udbdba-ezmlmshield-x39351332.[Email address protected] To:
om> "LazyDBA Discussion"
<[Email address protected]
cc:
Wednesday February 23, 2005 05:25 PM Subject: Re: Configuration Parameters










It will make adjustments. Setting those parms that way is kind of counter
productive.





"Richard Hagedorn
"
<db2udbdba-ezmlms To
hield-x43124568.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

02/23/2005 12:37 Subject
PM Configuration Parameters










Using UDB DB2 ver 7.2 for AIX



I noticed that the SORTHEAP is set to 51200 and SHEAPTHRES is set to 20000.

Since the sort heap cannot exceed the sort heap threshold, clearly these
values are meaningless from a tuning point of view.

Now my question is what does DB2 do when it encounters such conflicting
values ? Does it simply go and use the default values ? or does it treat
the
sort heap threshold as the correct value and makes ajustments to the sort
heap accordingly ?

As an extension of this question, my question is how does db2 handle the
values at the database level when they don't agree with what is specified
at
the database manager level ?

There are many db parameters(such as buffpage, dbheap,logbufsz etc) that
make up the database global memory. Same with private memory, that is there
are many parms that go into defining the private memory.

So how does db2 reconcile the discrepancies that arise from setting the
incorrect values (values that either don't make sense or simply cannot be
done) of various configuration parameters ?

looking forward to hear from you all.



thanks and regards,

RICHARD





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