Scatter factor

>--- In vantage@y..., "Winter, Patrick" <pjw@s...> wrote:
>> What is the procedure for measuring the scatter factor of a progress
>> database?
>> At what scatter factor should a dump & load be performed?
>>
>> Patrick Winter
>> sSc Specialty Screw Corporation
>> Vantage 5.00.338, Progress 9.1a
>
>Not sure how to figure it out, but this is the reply I got from
>Support about the "ideal" scatter factor and when a dump -n- load
>should be performed.
>
>"Progress recommends that a "perfect" database would be at 1.0. Its
>pretty impossible to get that, however, and they say that 2.0-3.0 is
>recommended."
>
>Erik

Use Proutil with the TABANALYS option. Here, I snipped this from the Progress 9.0B documentation, I'm sure the syntax will work with all 9.x (and probably 8.x) versions.

------ SNIP -------

To determine the degree of fragmentation for tables in a database, use the PROGRESS Utilities (PROUTIL) utility with the TABANALYS qualifier:

proutil db-name -C tabanalys

You can run PROUTIL with the TABANALYS qualifier while the database is in use; however, PROGRESS generates only approximate information.

----- SNIP -----

Progress System Administration Guide Copyright 1998 Progress Software Corporation.



Hope this helps,

Pete Wutzke <prw@...>
IS Manager
Giddens Industries