>-----Original Message-----
>From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
>Werner Baur
>Sent: Sunday, September 24, 2000 11:19 PM
>To: ADSM-L AT VM.MARIST DOT EDU
>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?


Hallo Herr Baur,

Sheelagh Treweek hat, soweit ich weiss, die Volume Groups an einem anderen
Rechner importiert.

Wir haben bisher immer erst den Diskplattenpool leer migriert, danach einen
vollen Datenbankbackup vorgenommen und mit "dsmserv restore db todate=today"
den Server auf dem anderen Rechner wieder hochgezogen. Es geht zumindest
mit 3590E1A-Laufwerken relativ schnell.

viele Gruesse,
Kirsten Gloeer
------------------------------------------------------------------------
Kirsten Gloeer                  e-mail: gloeer AT rz.uni-karlsruhe DOT de
Kirsten Gloeer                  e-mail: gloeer AT rz.uni-karlsruhe DOT de
Universitaet Karlsruhe          Phone:  +49 721 608-6156
Rechenzentrum                   Fax:    +49 721 32550
Postfach 6980
76128 Karlsruhe
------------------------------------------------------------------------
>
>
>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:baur AT lrz DOT de
>D-80333 Muenchen, Germany      http://www.lrz.de
>