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