ADSM-L

DB Volume "Reorg" using Delete DBVOLUME

2002-09-20 08:18:50
Subject: DB Volume "Reorg" using Delete DBVOLUME
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 20 Sep 2002 00:21:22 -0400
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

<Prev in Thread] Current Thread [Next in Thread>