-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] >Sent: Friday, September 20, 2002 12:21 AM >To: [EMAIL PROTECTED] >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:[EMAIL PROTECTED] Mail:150 Dorset Street,#292 South Burlington,VT 05403 Phone:802-863-7928 Fax:802-863-7937