Re: ADSM Database reduction question

Hi  Robert,

If the field 'Maximum Reduction is greater than a DB volume,
ou can reduce the db and delete the db volume and ADSM will
move the data onto another volume.

Herve

For instance, I can only remove 1 unused volume
3228 - 1836 = 1382 Mb

adsm> q db

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
---------     --------     ---------     ---------     -------
---------     ---------     -----     -----
---------     ---------     -----     -----
    7,328        7,328             0         3,228       4,096
    7,328        7,328             0         3,228       4,096
1,875,968     1,047,516      55.8      56.0

Volume Name         Copy      Volume Name         Copy      Available
Allocated   Free
(Copy 1)            Status    (Copy 2)            Status    Space (MB)
Space (MB)  (MB)
------------------- ------    -------------------   ------  ---------
---------  -------
---------  -------
/adsm/db/db11/db111 Sync'd    /adsm/db/db21/db211   Sync'd  1,836
/adsm/db/db11/db111 Sync'd    /adsm/db/db21/db211   Sync'd  1,836
1,836           0
/adsm/db/db11/db112 Sync'd    /adsm/db/db21/db212   Sync'd  1,828
1,828           0
/adsm/db/db12/db121 Sync'd    /adsm/db/db22/db221   Sync'd  1,836
1,836           0
/adsm/db/db12/db122 Sync'd    /adsm/db/db22/db222   Sync'd  1,828
1,828           0






ROBERT.BURTON AT ROYALBANK DOT COM on 01/02/2000 17:14:00
To:     ADSM-L AT VM.MARIST DOT EDU
cc:      (bcc: Herve Chibois/FR/ABNAMRO/NL)
Subject:        ADSM Database reduction question

We have a 23,576 MB database, that originally was running at 94% utilised.
By moving clients to other servers and
deleting filespace we have reduced our capacity to 37.3%.  We are trying
to
reclaim some database volumes.
We have a spare 1112 MB of free space in the database.  According to my
calculation 37% of 23576 MB is approx.
9000 MB which means we have large quantity of wasted space in the
database.

Is there anyway to compress the database to get rid of the wasted free
space?  I tried deleting database volumes using our freespace in the
database. This did not reclaim the space on the deleted volume it just
copied the volume being deleted (valid data & space) to the freespace.

Any suggestions would be appreciated....


Robert Burton
Open Systems Storage Analyst
Royal Bank of Canada
(416) 348-3849
Robert.Burton AT RoyalBank DOT com