ADSM-L

Re: [ADSM-L] Moving the TSM DB2 database (AIX)

2014-03-21 03:23:17
Subject: Re: [ADSM-L] Moving the TSM DB2 database (AIX)
From: rees_chris <rees_chris AT HOTMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 21 Mar 2014 07:20:45 +0000
Hi

I did exactly this last week but I used migratepv instead of the mirroring 
approach. I was moving from ds8100 to ds8870.  Mirroring method will be fine.

Cheers


Sent from Samsung Mobile

-------- Original message --------
From: Roger Deschner <rogerd AT UIC DOT EDU>
Date:21/03/2014  03:35  (GMT+00:00)
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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.=====