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:[EMAIL PROTECTED]] > Sent: Wednesday, June 26, 2002 3:16 PM > To: [EMAIL PROTECTED] > 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:[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 > > > > > >
