ADSM-L

Re: [Wayne, you need to use a subject line when you submit a post] How to do a db load/unload

2002-10-08 13:22:15
Subject: Re: [Wayne, you need to use a subject line when you submit a post] How to do a db load/unload
From: Mark Stapleton <stapleto AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 8 Oct 2002 12:20:07 -0500
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Wayne Gorton
> I've been thinking about the time it take s to unload and load a TSM DB.

Do yourself a favor. Don't.

There is no evidence that unloading and loading a TSM database has lasting
benefit. There is only anecdotal evidence that it has any benefit at all;
most of those who have done it have found that the database puts itself
right back where it was within a few weeks.

TSM's database really is self-tuning, folks. If you do a truly massive
expiration, there seems to be some unbalance of the tree, but even that
seems to fix itself within a few days. It is certainly not worth being
offline for 24 to 36 hours.

--
Mark Stapleton (stapleton AT berbee DOT com)
Certified TSM consultant
Certified AIX system engineer
MCSE

<Prev in Thread] Current Thread [Next in Thread>
  • [no subject], Wayne Gorton
    • Re: [Wayne, you need to use a subject line when you submit a post] How to do a db load/unload, Mark Stapleton <=