How long did these benefits last?  We are going to do the same thing,
with a 48GB database.  On our test system, it was redeuced to 26GB, but
I have no load there to find out how long the benefits will last, and
how often I will have to do this.


Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Mon, 13 May 2002, Michael, Monte wrote:

> Rajesh,
>
> I have performed an unload/reload of our AIX TSM server, and recieved the
> following results:
>
> Reduced database utilization by - 21.2%
> Reduced used database pages by - 3,114,592
> Maximum database reduction increased by - 22,044mb
>
> Our TSM production database is 60gb in size.  It took 8.5hrs to unload the
> database, and 4.0hrs to reload the database.  Two of the biggest benefits
> that we saw were a reduction of runtime for Expire Inventory, and the time
> it took to perform a FULL TSM Database backup.
>
> Monte
> Pioneer Hi-Bred International
>
> -----Original Message-----
> From: Rajesh Oak [mailto:rajeshoak AT LYCOS DOT COM]
> Sent: Friday, May 10, 2002 8:41 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Unload db/Loaddb
>
>
> 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
>