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:[EMAIL PROTECTED]] > Sent: Friday, May 10, 2002 8:41 AM > To: [EMAIL PROTECTED] > 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 >