Re: Database fragmentation formula (was Re: Online DB Reorg)

[Wayne T. Smith]

Hi Zlatko,

If I plug into your formula, I get ...

     1492.648         0.81294         14396.60        95.29128

(clearly under utilized).

But (ADSM V3.1(ancient)) shows ...

Available Assigned   Maximum   Maximum    Page     Total      Used   Pct
 Max.
    Space Capacity Extension Reduction    Size    Usable     Pages
Util   Pct
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages
   Util
--------- -------- --------- --------- ------- --------- --------- -----
-----
   16,380   15,136     1,244        28   4,096 3,874,816   183,609
4.7  38.5
This concurs with your utilization calculation, but note I have no DB
reduction possible.  I'm just noting this strangeness (fragmentation!?)
for you, since my ADSM is so old and is being retired.
Cheers and thanks for all the great insight you give on ADSM-L, wayne
--
Wayne T. Smith -- [EMAIL PROTECTED] -- University of Maine System -- UNET