Richard, it all depends on your situation. If you're going to use the unload/load feature of TSM, you'll need to do it regularly. Otherwise, over time, you'll loose the benefits of the unload/load process.
However, if you setup a routine to do the unload/load perhaps once a year, you will get a benefit out of using this feature. When we made the unload/load of the 160GB database, we not only saw the database shrink in its usage, but also gained alot of performance. This performance benefit is actually not degrading that quickly, which, for us, made the unload/load process worth the time. Best Regards Daniel Sparrman ----------------------------------- Daniel Sparrman Chef Utveckling & Drift Exist i Stockholm AB Propellervägen 6B 183 62 TÄBY Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-10-08 16:28 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Re: AW: DSMSERV UNLOADDB On Oct 8, 2004, at 9:47 AM, David Nicholson wrote: > Hi All, > I am surprised by the significant reduction is Pct Utilized. I > thought in previous discussions that Unload/Reload had minimal impact > on > utilization. I have (2) TSM 5.2.2 servers on AIX with 40GB db's that > are > 90% used. I haven't done a unload/reload since there creation 3 years > ago...do I have an opportunity here? The previous discussions I recall stressed minimal benefit over any significant period of time, which is to say that the risk and outage involved in the procedure isn't worth it. Richard Sims
