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: Orville.Lantto AT dtrend DOT com
V: 952-931-1203





Andrew Carlson <andyc AT ANDYC.CARENET DOT ORG>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/10/02 04:11 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        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
>