I would re-org my database for a performance increase, it would be to gain
some free space...

My .02
Mark


-----Original Message-----
From: Mark Stapleton [mailto:stapleto AT BERBEE DOT COM]
Sent: Monday, January 20, 2003 3:22 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: database reorganisation


On Fri, 2003-01-17 at 04:30, Francois Chevallier wrote:
> What are the best criteria to know if it's time to reorganize the tsm
> database (by unloaddb /loaddbb)

It's almost *never* time to unload and load your TSM db. Most of those
who have done so to "fix" a fragmented db discover that the system will
go back to its original state in a matter of days or weeks.

The real way to improve db performance is to place your db volumes on
fast-access disk (SSA, etc.)

--
Mark Stapleton (stapleton AT berbee DOT com)

Confidentiality Note: The information transmitted is intended only for the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.