Andrew, We've run the unload on both Wintel and Sun based TSM backup servers that were about 15 - 20GB in size and 80 - 90% utilized. Our expiration process went from 2 hours to 30 minutes and so far our benefits are good for about a year. We had the Lotus Notes Connect Agent eating up a ton our DB pages which was why we needed to run it yearly. So, it's going to depend on how many objects go in and then expired out of your DB to really determine when you run the unload.
Just my thoughts... Brian Scott EDS - Enterprise Distributed Capabilities MS 3278 Troy, MI 48098 * phone: 248-265-4596 (8-365) * mailto:[EMAIL PROTECTED] -----Original Message----- From: Andrew Carlson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 7:31 AM To: [EMAIL PROTECTED] Subject: Unload/Loaddb Question: what happens after a little time passes I asked this before, but did not see an answer. I did a test unload/load on my test server, and saw a 44% reduction in the database. My selects ran with blazing speed, even on a much smaller box than the production box. What I wanted to know, from people that have seen significant reductions, how long do the benefits last? The database has a percent changed of around 10% a day. It seems like this could quickly make these benefits "go away", but if the same, or close, 10% of the database changes, the benefits might stay awhile. I am trying to figure out if I will need to do this again in 6 months, a year, or more, or less. Thanks for any info. I know that, when I do this, I will find out myself, but we are not doing it til July 4th weekend, and I just wanted to get some idea what other people are seeing. Andy Carlson |\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_ BJC Health Care |,4- ) )-,_. ,\ ( `'-' St. Louis, Missouri '---''(_/--' `-'\_) Cat Pics: http://andyc.dyndns.org/animal.html
