Re: Moving DB
1999-03-25 16:30:18
And while you're at it, don't forget to DEFINE DBCOPY to mirror
your database and recovery log volumes. Or is this belt and
suspenders on a RAID-5 system?
"Just because you're paranoid doesn't mean they're not out to get you."
Rich
At 03:57 PM 3/25/99 -0500, you wrote:
>>>>
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
Richard C. Dempsey email: dempsey AT kodak DOT com
Public Online Services pager: 716-975-3539
11th Floor, Bldg 83, RL phone: 716-477-3457
Eastman Kodak Company
Rochester, NY 14650-2203
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Moving DB, Fred Johanson
- Re: Moving DB, Richard Sims
- Re: Moving DB, Kauffman, Tom
- Re: Moving DB, Thomas A. La Porte
- Re: Moving DB,
Richard C. Dempsey <=
- Re: Moving DB, Purdon, James
- Re: Moving DB, Nichols, Linnea
- Re: Moving DB, Fred Johanson
- Re: Moving DB, Richard Sims
- Re: Moving DB, Purdon, James
- Re: Moving DB, Bruce Elrick
- Re: Moving DB, Fred Johanson
- Re: Moving DB, Dusedau, Stefan
- Re: Moving DB, Richard C . Dempsey [mailto:dempsey
|
|
|