> Right now I am trying a dump/loaddb of one of the lareger ADSM databases.
Please let me know how this turns out! I have a customer with a very
similar
environment as yours and they are going to unload/reload a 70GB db on an R50
shortly.
--
Joshua S. Bassi
Senior Technical Consultant
Symatrix Technology, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Werner Baur
Sent: Sunday, September 24, 2000 11:19 PM
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
