-----Original Message-----
From: edsaul AT alum.wpi DOT edu [mailto:edsaul AT alum.wpi DOT edu]
Sent: Friday, September 20, 2002 4:50 PM
To: Nelson, Doug
Subject: Re: FW: DB Volume "Reorg" using Delete DBVOLUME


Hi Doug -

It used to be pretty difficult to re-org the TSM database - but it was
also considered unnecessary. It still is considered unnecessary - but
there is at least one way to do it. It was discussed at the Storage
Conference last year. I will research it. Several other approaches,
including the one he asks about, move lots of data around - but do not
necessarily actually "reorg" the data in a true database sense. The one
I remember does a true unload and reorg/reload of the whole DB. Things
like Delete DBvolume I believe do not include a  reorg because that
would make them much slower. I have heard of very large shops doing a
re-org after several years and getting a benefit from it - but it takes
a long time and very few shops ever do it.

Ed
---

Nelson, Doug wrote:

>Ed, Weren't we just talking about this yesterday? Do you have any
experience with it?
>
>-----Original Message-----
>From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
>Sent: Friday, September 20, 2002 12:21 AM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: DB Volume "Reorg" using Delete DBVOLUME
>
>
>One of our TSM Support Staff members went to the advanced class and was led
>to believe you could get some reorg benefits doing the following
>
>        Define New DB Volumes whereever you want them.
>        Perform DELETE DBVOLUME commands on each of the existing DBVOLUMEs
>one at a time which causes the data to be moved.
>
>Our DBVOLUMES are on ESS disk so they are not mirrored.  Thus, the delete
>causes a move of all the current data to other volumes.
>
>Has anyone ever heard of doing this to get some reorganization benefits?
>If so, were the benefits, mild or significant?
>
>I would not be surprised if massive filespace deletes could be recaptured
by
>doing this.
>
>Paul D. Seay, Jr.
>Technical Specialist
>Naptheon Inc.
>757-688-8180
>
>

--
Ed Saulnier

An IBM "TCI" Business Partner and Contractor
Specializing in Storage and Systems Management Solutions
A Tivoli Certified Consultant in Tivoli Storage Management

Coolidge Systems Inc.        email:edsaul AT alum.wpi DOT edu
Mail:150 Dorset Street,#292  South Burlington,VT 05403
Phone:802-863-7928                    Fax:802-863-7937