I did this on a 2-way 340MHZ RS-64 H70. I was using TSM4.3.3, so
obviously it was in 32 bit mode. The box has 1GB memory, and I was
using SAN disk for the database, and striped SCSI disk for the flat
file.
Andy Carlson |\ _,,,---,,_
Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_
BJC Health Care |,4- ) )-,_. ,\ ( `'-'
St. Louis, Missouri '---''(_/--' `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html
On Thu, 27 Jun 2002, Ritter, Tom wrote:
> On what platform did you do this unload/reload. I'm trying to make a guess
> at how long out unload/reload might run. So, CPU type, speed, memory, etc
> would be important to know.
>
> Thanks,
>
> Thomas S. Ritter
> Promedica Health System
> Technical Coordinator
> (419) 291-0049
>
> -----Original Message-----
> From: Andrew Carlson [mailto:andyc AT ANDYC.CARENET DOT ORG]
> Sent: Wednesday, June 26, 2002 3:16 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: UnloadDB - LoadDB is it worth it?
>
> On out test box, it took 16 hours to unload, and 7 hours to load. I
> started an unneeded audit, just to see how it would go, and I estimated
> it would take 92 hours.
>
>
> Andy Carlson |\ _,,,---,,_
> Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_
> BJC Health Care |,4- ) )-,_. ,\ ( `'-'
> St. Louis, Missouri '---''(_/--' `-'\_)
> Cat Pics: http://andyc.dyndns.org/animal.html
>
>
> On Wed, 26 Jun 2002, Ritter, Tom wrote:
>
> > Andy, thanks for the response. How long did the whole process take?
> >
> > Thomas S. Ritter
> > Promedica Health System
> > Technical Coordinator
> > (419) 291-0049
> >
> > -----Original Message-----
> > From: Andrew Carlson [mailto:andyc AT ANDYC.CARENET DOT ORG]
> > Sent: Wednesday, June 26, 2002 10:29 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: UnloadDB - LoadDB is it worth it?
> >
> > I have done it in test, but not production til next week. Out DB went
> > from 46GB to 26GB. I was able to do selects from the database that
> > would never finish on the prod system. I obviously have no idea of the
> > long term effects are.
> >
> > Andy Carlson |\ _,,,---,,_
> > Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_
> > BJC Health Care |,4- ) )-,_. ,\ ( `'-'
> > St. Louis, Missouri '---''(_/--' `-'\_)
> > Cat Pics: http://andyc.dyndns.org/animal.html
> >
> >
> > On Wed, 26 Jun 2002, Ritter, Tom wrote:
> >
> > > I was reading the TSM Admin guide where it recommends that you
> > periodically
> > > do a reorg of the database. We have had our TSM server running since
> 1998
> > > and have never done a reorg. Our database is around 65G. We're running
> > TSM
> > > 4.2.1.11 on OS/390.
> > >
> > > Thomas S. Ritter
> > > Promedica Health System
> > > Technical Coordinator
> > > (419) 291-0049
> > >
> >
>
|