In addition to HOWMESSY and DBGeneral, there used to be a CSL program called
DBSTAT2 (back in the 80's) that gave a graphic "map" of a dataset showing
how the entries were distributed.

Does anybody know if this program still exists. We recently had a problem
with secondaries and integer keys that we diagnosed with HOWMESSY, but we
were looking for a program to show us the distribution so that we could
reset our key to point to an empty spot.

I understand that DBGeneral can produce a graphic representation but we were
looking for an inexpensive (free) utility.

-----------
Jerry Fochtman wrote:

> <plug>
>
> In addition to HowMessy (which has been mentioned by others), DBGeneral's
> diagnostics will evaluate secondary entries in several ways.  The user is
given
> information on the number of secondaries, the average chain length for all
> secondary
> entries as well as the longest chain length.  In addition, the secondary
> entries are
> evaluated for their locality relative to adjacent entries within the chain
> in an effort to
> estimate the potential for I/O page faults.   Based upon this information
> DBGeneral may
> recommend that the dataset be reorganized in order to improve
> performance.  However,
> armed with this data, coupled with knowledge about how the data is
> accessed/used,
> will help the database administrator determine what may be the best course
> of action.
>
> <\plug>
>

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