Re: UnloadDB - LoadDB is it worth it?

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
> >
>