ADSM-L

Re: Relocating TSM DB (storage)

2002-11-22 10:56:57
Subject: Re: Relocating TSM DB (storage)
From: John Wright <John.J.Wright AT GSK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 22 Nov 2002 15:46:07 +0000
Any idea if moving database data between volumes like this will free any
fragmented space as it moves the data?

Cheers
John



                    "Zlatko
                    Krastev/ACIT"
                    <[email protected]
                    L.NET>               To:     ADSM-L

                    Sent by:             cc:
                    "ADSM: Dist          Subject:     Re: Relocating TSM DB 
(storage)
                    Stor Manager"
                    <ADSM-L AT VM DOT MAR
                    IST.EDU>


                    22-Nov-2002
                    15:17
                    Please respond
                    to "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MAR
                    IST.EDU>





Think for "available" as total space and for "assigned" as maximum used.
This is like hot-spare disk you may or may not put in your RAID array.
TSM allows a volume to be deleted only if it is smaller than Available
minus Assigned, i.e. there is available but unassigned space to move data
from volume to be deleted.

Zlatko Krastev
IT Consultant






"Robert L. Rippy" <robert_rippy AT KINDREDHEALTHCARE DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
22.11.2002 16:49
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Relocating TSM DB (storage)


If you don't extend and create more 'available' space, then how is there
space available to move the DB's to when you start deleting volumes?
Before TSM can use DB space, you must extend and make the space available
for use.

Thanks,
Robert Rippy




From: Andy Carlson <andyc AT ANDYC.CARENET DOT ORG> on 11/22/2002 09:42 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: Relocating TSM DB (storage)

Do not extend the DB before doing the delete dbvol.  The delete command
uses the empty, enextended space to move the data from the volumes to be
deleted.


Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Fri, 22 Nov 2002, Robert L. Rippy wrote:

> Yes, you are correct. Create the new DB's and extend the DB and then
delete
> the old DB's. The data will migrate over to the new extended space. Any
> reason you had 37 1GB volumes for your DB's. IBM told me not to really
go
> over 10 volumes on your DB and to be sure they aren't on the same drive
if
> you can help it.
>
> I would suggest that if you could, create 5 8GB new volumes for a total
of
> 40GB and move the DB over to the new 8GB partitions.
>
> Thanks,
> Robert Rippy
>
>
>
> From: "Thach, Kevin" <KThach AT COVHLTH DOT COM> on 11/22/2002 09:30 AM
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> To:   ADSM-L AT VM.MARIST DOT EDU
> cc:
> Subject:  Relocating TSM DB (storage)
>
> I am wanting to move our TSM DB which is currently on ESS, and has 37
1GB
> dbvolumes, to another set of ESS disk.  If I define the new dbvolumes on
> the
> new disks, do I then just extend the db, and then do a del dbvol on the
old
> ones?  Does the delete make the data migrate over?
>
> Do I have to do a reduce db for any reason before I do the delete dbvol?
> Can I do the delete with the server up and running?
>
> Thanks
>
> This E-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
only
> for the use of the Individual(s) named above.  If you are not the
intended
> recipient of this E-mail, or the employee or agent responsible for
> delivering it to the intended recipient, you are hereby notified that
any
> dissemination or copying of this E-mail is strictly prohibited.  If you
> have
> received this E-mail in error, please immediately notify us at (865)
> 374-4900 or notify us by E-mail at hdesk AT covhlth DOT com.
>