We've done the SSA disconnect and reconnect trick and found it pretty slick.
It is really good if you are in production because you can install the
server on the new machine test to make sure it is installed ok. Switch over
in about half an hour and be running again with just a little break
-----Original Message-----
From: Werner Baur [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 1:19 AM
To: [EMAIL PROTECTED]
Subject: Re: ADSM 3.1.2.40 DB unload/reload
I'm very pleased to move 5 ADSM servers to new machines until end of year.
In
order to be prepared to this interesting task I am evaluating some ways to
go.
Right now I am trying a dump/loaddb of one of the lareger ADSM databases.
Database size is about 70 GB, 550,000,000 entries. Dump db on a RS/6000 R50,
AIX
4.2.1, ADSM 3.1.2.57, was pretty fast (7 hours). For load db on a RS/6000
S7A, AIX
4.3.2, you should provide some more time, at our environment 4 days. So we
can
safely exclude dump/load db as a way to move an large adsm server. A
interruption
of service for so many days is not acceptable.
BTW: Does anyone have an idea how to move an production server from one
machine to
another? The db is resided on SSA disks. So, in theoretically, we can attach
the
SSA loop to the new machine, issue an import volume group and that's it. Has
anybody done this before?
Any hints are welcome,
Werner
Tim Melly wrote:
> Hi all,
>
> There was a recent inquiry concerning *SM DB unloading-loading and the
> potential benefits/drawbacks.
> The stated benefit was a significant reduction in DB size (>90% to 52%)
but the
> drawback was that the process took
> approximately 24 hours (this was on a 46 GB DB).
>
> I'm running ADSM 3.1.2.40 on an AIX 4.3.2 SP node (4-way F50 equivalent
w/1GB
> memory) and have a 19 GB DB. I have some disk space available and was
thinking
> about doing the unload-reload to disk. I'm hoping this significantly
reduces
> the processing time.
>
> Has anyone else attempted to do this in an AIX environment and if so what
were
> your results? Was it worthwhile?
>
> Also, I didn't see anything in the ADSM Admin. Reference manual about
> "unloading" the *SM DB.
> How is this done?
>
> Thx for any and all input, Tim Melly
> Bayer Pharmaceuticals
--
Werner Baur Tel.:++49-89-28928781
Leibniz-Rechenzentrum Fax:++49-89-2809460
Barer Str. 21 mailto:[EMAIL PROTECTED]
D-80333 Muenchen, Germany http://www.lrz.de
