ADSM-L

Re: unload/reload db on diff.server (same library) -- disaster waiting to happen?

2003-03-09 16:21:50
Subject: Re: unload/reload db on diff.server (same library) -- disaster waiting to happen?
From: "Stapleton, Mark" <stapleto AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 9 Mar 2003 15:21:14 -0600
From: Adam J. Boyer [mailto:Adam.J.Boyer AT FRB DOT GOV] 
> Due to some misunderstanding, an unnecessary 5 million files 
> was backed up, bloating our database by about 15 GB.  I have 
> since commenced deleting that filespace, but it looks like 
> the delete is not reducing the database size nearly enough.  
> So I am planning to do an unload/reload, and in order to 
> eliminate downtime,
<snip>
> The only downside I can think of is that after the 
> reorganized database is restored to the production server, 
> all transactions made during the
> unload/reload will be lost.

Don't do it. You'll be spending months fixing it, and it'll never get
fixed. (Besides, an unload/load of the db won't get you what you want.)

What command did you use to delete the filespace? Did you run an
expiration after the deletion?

--
Mark Stapleton (mark.stapleton AT berbee DOT com) 

<Prev in Thread] Current Thread [Next in Thread>