My db shrank a lot also, but re-grew a fair bit over the next week. I suspect it will reach a steady-state value not much different than I started with.
Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) 121 Cheshire Lane #700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] V: 952-931-1203 Andrew Carlson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 05/10/02 04:11 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: Unload db/Loaddb I missed the first message in this thread, but I have been testing this. This is what I plan to do: - wait for DB backup to complete - enter 'halt quiesce" command so the db should be consistent - unloaddb (to disk) - loaddb (from disk) In testing, with out full size DB (47.9GB), it went down to 28.6GB. I am very happy with the results, and am anxious to do it on the prod server. Andy Carlson |\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_ BJC Health Care |,4- ) )-,_. ,\ ( `'-' St. Louis, Missouri '---''(_/--' `-'\_) Cat Pics: http://andyc.dyndns.org/animal.html On Fri, 10 May 2002, Nici Albrecht wrote: > You might want to check out the archives on this, there has been quite a > bit of discussion in regards to this issue. > > Nici > > At 09:41 AM 5/10/2002 -0400, you wrote: > >DOes anyone have a standard procedure for unloaddb and loaddb. > >I have TSM 4.2.1.11 on AIX. Our db is 36GB and is about 79 % full. > >Any gotchas while doing the unload and loaddb? > >Any help is appreciated. > > > >Rajesh Oak > > Nici Albrecht > MDR Consulting & Education, Inc. > 210-860-4641 >
