ADSM-L

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

2003-10-20 16:12:49
Subject: Re: Database fragmentation formula (was Re: Online DB Reorg)
From: "Wayne T. Smith" <ADSM AT MAINE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 20 Oct 2003 16:07:31 -0400
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 -- ADSM AT Maine DOT edu -- University of Maine System -- UNET