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
>