ADSM-L

Re: Can't reduce database

1997-09-30 12:38:34
Subject: Re: Can't reduce database
From: Sheelagh Treweek <sheelagh.treweek AT COMPUTING-SERVICES.OXFORD.AC DOT UK>
Date: Tue, 30 Sep 1997 17:38:34 +0100
> From owner-adsm-l AT VM.MARIST DOT EDU  Tue Sep 30 17:08:07 1997
> Date: Tue, 30 Sep 1997 08:42:43 -0400
> From: Steven P Roder <tkssteve AT ACSU.BUFFALO DOT EDU>
> Subject: Re: Can't reduce database
>
> Just go ahead and delete a volume.  ADSM will move any in use pages to
> other volumes.
>

Steve,

One of us has missed Trevor's point I think ...

What I was answering is better explained with these examples below.

You can only reduce a DB if there are pages in the "Maximum Reduction (MB)"
so in this case ...

adsm> q db

Available Assigned   Maximum   Maximum    Page     Total      Used %Util  Max.
    Space Capacity Extension Reduction    Size    Usable     Pages       %Util
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages
--------- -------- --------- --------- ------- --------- --------- ----- -----
   49,056   39,840     9,216     1,560   4,096 10,199,04 9,795,826  96.0  96.1
   49,056   39,840     9,216     1,560   4,096 10,199,04 9,795,826  96.0  96.1
                                                       0

...  you could reduce this db here by 1560 and then delete dbv's (if they
match the size - ours are 2GB each so I couldn't).

In the next example ...

adsm> q db

Available Assigned   Maximum   Maximum    Page     Total      Used %Util  Max.
    Space Capacity Extension Reduction    Size    Usable     Pages       %Util
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages
--------- -------- --------- --------- ------- --------- --------- ----- -----
   36,216   34,480     1,736         0   4,096 8,826,880 6,663,969  75.5  75.5
   36,216   34,480     1,736         0   4,096 8,826,880 6,663,969  75.5  75.5

...  you will see "Maximum Reduction (MB)" is 0.  %Util is 75.5% - I made
this DB with restore db from my original, deleted a lot of nodes and I can
reduce the physical size no more.

This, the second one, is the scenario I thought Trevor was asking about.

Regards, Sheelagh

------------------------------------------------------------------------------
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Oxford University Computing Services     Tel:   +44 (0)1865 273205
13 Banbury Road, Oxford, OX2 6NN, UK     Fax:   +44 (0)1865 273275
------------------------------------------------------------------------------
=========================================================================
<Prev in Thread] Current Thread [Next in Thread>