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
Werner Baur                    Tel.:++49-89-28928781
Leibniz-Rechenzentrum           Fax:++49-89-2809460
Barer Str. 21                mailto:baur AT lrz DOT de
D-80333 Muenchen, Germany      http://www.lrz.de