Thanks to all. AIX migraepv is the make/break mirror method. We will
probably proceed that way during the relative calm of Spring Break.

As for the database restore, we've never done one under V6 yet. Our full
DB backups are running about 45 minutes to local LTO5 or 1:15 to an
offsite SAN over the hill and through the woods. Sounds like it will be
a lot better than with V5. My only experience has been the V5 to V6
conversion.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
======I have not lost my mind -- it is backed up on tape somewhere.=====



On Fri, 21 Mar 2014, Prather, Wanda wrote:

>Was just thinking the same -
>It's only the conversion from V5 to V6 that takes forever.  Once you are 
>V6/DB2, DB backup-restore is fast again.
>
>I have TSM 6.3.4 on Windows, DB is 930G used, DS3512 disk, and it will back up 
>to LTO5 in 90 minutes if the server isn't doing a lot else at the time.  
>Restore takes maybe 15 minutes longer.
>
>You've got other issues you should address, if your DB backup is taking many 
>hours @ 300GB....
>
>W
>
>
>-----Original Message-----
>From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
>Of Ehresman,David E.
>Sent: Friday, March 21, 2014 9:11 AM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: [ADSM-L] Moving the TSM DB2 database (AIX)
>
>I've used migratepv to move oracle DBs around with no problems.  I would not 
>expect any issues with using LVM mirroring or migratepv to move the TSM DB.  
>That is what I would do in your situation.
>
>But your comments about taking days to backup and restore your TSM DB worries 
>me.  How long does it take to backup your DB?  I have a 600G allocated/415G 
>used TSM DB.  It backs up in under an hour and restore time is about the same.
>
>David Ehresman
>University of Louisville
>
>-----Original Message-----
>From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
>Of Roger Deschner
>Sent: Thursday, March 20, 2014 11:35 PM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: [ADSM-L] Moving the TSM DB2 database (AIX)
>
>Now that TSM V5 is gone from our shop and we're all TSM V6.2, it's time to 
>move some things around. Such as the TSM DB2 database. The manual says to do a 
>full database backup and restore. That could take days of downtime with our 
>150-300GB databases, and a lot of angst, so that is not really acceptable.
>
>What I'm planning to do instead, is what I've always done on AIX. It's one of 
>the reasons I like AIX for hosting something like TSM. That is, to basically 
>walk the database over to the new location using AIX LVM mirroring. All this 
>with TSM up and running, albeit with a performance impact. (It's Spring Break, 
>so the performance impact is acceptable.) The end result will be that the 
>database has exactly the same Unix filesystem names, path names, and file 
>names as before, except that it will be on a nice new faster disk subsystem.
>
>Other than the obvious performance impact while AIX LVM is doing the 
>mirroring, is there anything wrong with moving a TSM DB2 database by this 
>method? Anybody done this and had problems?
>
>Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
>======I have not lost my mind -- it is backed up on tape somewhere.=====
>