> 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
------------------------------------------------------------------------------
=========================================================================
|