He's a dba, he can't help himself!  He see's a database, he reorg's the
database.  I know from reading this list that a db reorg isn't often
recommended.  Problem is there is another dba up there, who has some TSM
experience, who says she used to do it painlessly.  Anyone want to weigh
in?

Brett 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jurjen Oskam
Sent: Wednesday, August 30, 2006 3:21 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TSM Database Reorg

On Wed, Aug 30, 2006 at 03:12:51PM -0500, Whitlock, Brett wrote:

> I have a dba who is recommending I do a regularly scheduled database 
> reorg (ie weekly).  Anyone doing this?  Can you share the good,  the 
> bad, and the ugly about doing this?

The general consensus here is that it almost always isn't worth doing.

What reasons does the DBA provide for his recommendation?

Regards,
--
Jurjen Oskam