Hi, Bill.
I'm copying this to the list because someone else might benefit from the
explanation.
Yes, exactly. Let's take a dbvol for example. You have a volume,
/dev/rdbvol, or if using files, /path/dbvol. You instead want to move it
onto a different storage device which you've mounted on /newpath.
AIX: dsmfmt dbvol on /newpath
TSM: def dbvol /newpath/dbvol
del dbvol /path/dbvol
The del dbvol command will automatically move the data on /path/dbvol onto
/newpath/dbvol, assuming /newpath/dbvol is large enough, and then delete
/path/dbvol.
If you're using TSM dbvol mirroring, you'd have maybe database volume
/path/dbvol and a mirror copy on /path/dbvolcopy. Your options are to
ignore mirroring, or make sure it's mirrored before you do the delete.
Something like this.
AIX: dsmfmt dbvol /newpath/dbvol
dsmfmt dbvol /newpath/dbvolcopy
TSM: def dbvol /newpath/dbvol
def dbcopy /newpath/dbvolcopy
del dbvol /path/dbvol
del dbvol /path/dbvolcopy
The same process works for the log, also.
Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail
-----Original Message-----
From: Bill Fitzgerald [mailto:wfitzger AT mhc DOT net]
Sent: Friday, August 01, 2003 10:29 AM
To: AlexPaschal AT FREIGHTLINER DOT COM
Subject: Re: move of Database and Logfile
I am sorry to say I am confused
could you spell it out a bit more?
also, I am not clear as to how the data gets from the old files to the new
files......
if I understand it correctly if there is enough space in the database and
the copy, that when I delete a file and the copy from the database, the data
stored on those files are automatically moved to the empty space?
William Fitzgerald
Software Programmer
Munson Medical Center
wfitzger AT mhc DOT net
>>> AlexPaschal AT FREIGHTLINER DOT COM 08/01/03 01:12PM >>>
Hi, William.
It's pretty easy, pretty much the same thing as storage pools. You define
dbvol and logvol and logcopy and dbcopy onto the new storage, then del
dbvol, del logv, del logcopy, and del dbcopy the original volumes. When you
do the deletes, TSM automagically moves the data over. :)
OH, just in case, backup db first.
Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail
-----Original Message-----
From: Bill Fitzgerald [mailto:wfitzger AT MHC DOT NET]
Sent: Friday, August 01, 2003 8:58 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: move of Database and Logfile
I am in the process of moving the database, log file, and the disc based
storage pool from SSA drives to a FastT-600.
the move of the storage pools is straight forward adding space on the T-600
and then deleting the space from the other drives when the pool is empty
the db and log is what I need help with.
Has any one done this? what is the best way to do it? any tips, pit falls,
or advice you can give me is appreciated
William Fitzgerald
Software Programmer
Munson Medical Center
wfitzger AT mhc DOT net
|