ADSM-L

Re: move of Database and Logfile

2003-08-01 14:03:51
Subject: Re: move of Database and Logfile
From: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 1 Aug 2003 11:03:18 -0700
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

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