ADSM-L

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

2014-03-20 23:36:42
Subject: [ADSM-L] Moving the TSM DB2 database (AIX)
From: Roger Deschner <rogerd AT UIC DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 20 Mar 2014 22:34:41 -0500
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.=====