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