Hi Robert,

yes there is a way.

1. reduce your DB (Properties of DB in GUI under FILE) by the amount you
want.

2. remove one or more DB-Volumes ( so your database gest smaller)


If you have your whole DB in one DB-Volume, then first add, extend and
reduce again, to remove the old DB-Volumes.


_________________________________________________

Kind Regards
Andreas Buser

Tel: ++41 61 285 73 21  Fax: ++41 61 285 70 98

Email: Andreas.Buser AT Basler DOT ch

Address:
Basler Versicherungen
Andreas Buser
Abt. Informatik
Aeschengraben 21
4002 Basel
Switzerland



                    "Burton, Robert"
                    <ROBERT.BURTON@ROYA        An:     ADSM-L AT VM.MARIST DOT 
EDU
                    LBANK.COM>                 Kopie:
                    Gesendet von:              Thema:  ADSM Database reduction 
question
                    "ADSM: Dist Stor
                    Manager"
                    <[email protected]
                    DU>


                    01.02.00 16:57
                    Bitte antworten an
                    "ADSM: Dist Stor
                    Manager"





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