Dear ADSM LIST (whoever you are),
David Bohm's posting indeed describes, what's going on here: LOADDB does
not use the efficient, but the generic b-tree page split algorithm, which
results in a page utilization close to 50%. I was hoping for an option
which changes this behaviour.
So, if you have an inconsistency in a 25 GB database which cannot be
resolved by restoring it, you not only have to be prepared for several
weeks of outage, but also for having 15-20 GB of spare disk space...
ADSM LIST writes:
> Short of having access to CMVC and traces, I doubt I could say exactly why.
> But when a person adds 9GB(8G + 1G) to a database and it still has problems,
> I wouldn't be a happy camper. I'm sure someone in San Jose SSD can explain
> this one. It's a runaway malloc() or fopen()/fprintf()!
>
> Sure, it's more than reasonable to say you need more space. But that's what
> ADSM is there for, to take up space...:-)
>
> ADSML
>
> ADSM + AIX = "Add some aches"
> (ADSM) (AIX)
>
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On
> > Behalf Of
> > Richard Sims
> > Sent: Sunday, August 29, 1999 7:11 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: Space reqs on LOADDB
> >
> >
> > >Looks like there's some kind of problem with either the LOADDB mechanism
> > >or the structural integrity of the ADSM DB you're reloading.
> > >
> > >I'd attempt and EXPORT SERVER command of all data to have a clean
> > >preservation
> > >of what's in the ADSM DB. DBBackups could work, but the structure could
> > >prevent those from restoring properly. Also chekc the following...
> >
> > Please don't guess. Check the archives, at www.adsm.org, wherein the
> > December 1, 1998 posting by developer David Bohm describes why a LOADDB
> > takes more space.
> > Richard Sims, BU
> >
--
Reinhard Mersch Westfaelische Wilhelms-Universitaet
Reinhard Mersch Westfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany Tel: +49(251)83-31583
E-Mail: mersch AT uni-muenster DOT de Fax:
+49(251)83-31653
|