RE: Moving DB

Fred, if you're not moving to a new server there's no reason to go through this.

Define your new database logical volumes (and file systems, if you're going this route) to AIX on the new RAID box.
Then, as ADSM admin, define dbvolume <volume path> to ADSM.
And then - delete dbvolume <old volume path>

This will kick off a background process to move the database data from the old volume to the new. Do the delete for each of the old dbvolumes, until query dbvolume only shows the RAID system.

No down time required! (Never hurts to do the DB backup to tape first, though :-)

Tom Kauffman
Sr. Technical Analyst,
NIBCO, Inc

-----Original Message-----
From: Fred Johanson [SMTP:fred AT MIDWAY.UCHICAGO DOT EDU]
Sent: Thursday, March 25, 1999 3:43 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Moving DB

As ADSM has gone from a pilot project to a production system, the DB has
expanded to 10 pieces spread over 4 volumes (and mirrored). It's just
grown as expansion is need. Now, we have installed a RAID-5 system on the
server, and I want to move the DB to a single, coherent place on the new
devices and allow for a year or more of growth as I do so. As I understand
the procedure from the manual, I have to

1. DSMSERV DUMPDB devc=tape (defaulting to scratch)
2. DSMSERV FROMAT 1 newlogname 1 newdbname (both already defined by
DSMFMT??)
3. DSMSERV LOADDB devc=tape vol=scratch from 1

My hardware is a RISC/6000 AIX4.2.1, ADSM 3.1.2.13, with a 3494 tape
library and 4 3590 drives. I have a DEVCONFIG file already.

However, at least one thing in the manual has me confused: that I must use
a LIBTYPE of manual. Does this mean I have to edit the DEVCONFIG (or point
to another one) so that the LIBTYPE is manual? If so, do I have to use an
mtlib command to get a scratchtape mounted, rewound, and remounted? Any
help will be greatly appreciated.


Fred Johanson
System Administrator, ADSM
S.E.A.
University of Chicago
773-702-8464