Matt,

many people on this list have larger DB. What is your concern about the
database - performance, DB backup time, ... ? If there is a problem other
than size provide some details - version, DBVols and LOGVols storage type,
etc.
Unload/Load may help to reduce the DB but may not as well.
You can argue against no off-site reclamation. At the end through such
reclaim not only tape usage is better but also chance for tape errors due
to aging is minimized.

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Unload DB/LoadDB

I have a 45GB database.  It is approximately 11,500,000 pages.  Has anyone
tried or had success using the Unload/Load DB?  Is there another way that
I
can reduce this?  I have my ACTLOG retention set for 4 days.  I think what
is holding me back is we have our OFFSITE copy pool set for 9999.  We send
everything offsite forever (Not my idea).

Matt Adamson, MCSE
NDC MS Hardware Support
*desk:425.288.6286
*cell:206.601.8561
*mailto:matt.adamson AT attws DOT com <mailto:matt.adamson AT attws DOT com>