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:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 10:29 AM To: [EMAIL PROTECTED] 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 >