Exactly what David Gale said.

I would add that you really need to pay special attention to the Howmessy
report - especially the columns entitled "Max. Contiguous Blocks" and
%secondaries.

As long as the %secondaries is zero, it does not matter what the
Max.Contig.Blocks colomn shows.

As soon as the %secondaries is greater than zero, any significantly large
no. of max.blocks (say, greater than 100-500) can result in serious
performance degradation when adding master entries (keep in mind that this
adding can be indirect in the case of automatic masters.)

The solution to this situation often lies in simply increasing the capacity
of the master in question.

How much to increase can be a matter of trial and error - but, very
generally speaking, the larger the better.

Other columns in the Howmessy report can also help assess the "health" of a
data base.

For example, inefficient pointers and elongation can signify potential
performance problems associated with detail data sets.

I suggest reading the documentation accompanying howmessy for a more
detailed explanation

At 06:34 PM 2002-03-28, John Penney wrote:
>OK, 3000-L or those of you still with me at this hour:
>
>I seem to remember from a '79 D/B course that there was a percentage, 70
>or 75% above which you would experience degraded if not
>molasses-in-February performance, if you didn't adjust the dataset capacities.
>
>Anybody can quote the source for this quotation?
>
>TIA
>
>
>
>John M Penney
>Systems Programmer
>Production Services
>Information Services Department
>Pierce County
>Tacoma, WA
>253-798-6215
>253-798-6680 Fax
>[log in to unmask]
>www.co.pierce.wa.us
>
>The opinions expressed herein reflect those of the sender.  They do not
>necessarily
>reflect the opinions of Pierce County unless specifically stated otherwise.
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

-------------------------------------------------------------------------------------------------
Gilles Schipper
GSA Inc.
HP System Administration Specialists
300 John Street, Box 87651   Thornhill, ON Canada L3T 7R4
Voice: 905.889.3000     Fax: 905.889.3001
email:  [log in to unmask]  web: http://www.gsainc.com
-------------------------------------------------------------------------------------------------

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *