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 >
