Hi Andy,
my idea is similar to yours :
halt the server
copy my databases and logs (for fallback)
unloaddb to devclass=file
loadformat
loaddb
I don't think you have to make an auditdb if your unloaddb works with the
consistant-option (default) (Administrators Reference 'dsmserv unloaddb').
Where does the loaddb-process get the information about the database-volumes
to load from ? Does it use the dsmserv.dsk ? (Because the unloaddb-process
seems to get the information about names and directories of the db- and
log-files directly out of one of the db-files).
But I wanted to test it before running the processes on production to get an
idea about the runtime of the processes. Our database is about 24 GB and
with an unload-performance of about 2 GB (I tested with a smaller database)
it would take about 12 H and then I haven't yet reloaded the database.
And I heard about some problems with loaddb with some TSM-Versions, so I
have to have a quick fallback-strategy.
Best regards
Chris
> -----Ursprüngliche Nachricht-----
> Von: Andy Carlson [SMTP:andyc AT ANDYC.CARENET DOT ORG]
> Gesendet am: Mittwoch, 20. März 2002 18:10
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: UNLOADDB/LOADDB Scenario
>
> I have been kicking around the idea of doing and unload/load of the
> database. Here is a scenario I came up with, to possibly cover my bases
> if the load goes badly:
>
> UNLOADDB to a disk file
> LOADFORMAT one of my mirrored DB and mirrored LOG
> LOADDB
> AUDITDB (do I really have to do this?)
>
> The advantage is that if I cannot load the DB for some reason, I still
> have my other mirror that I could update the dsmserv.dsk file and
> restart TSM. Is this feasible? Thanks.
>
> Andy Carlson |\ _,,,---,,_
> andyc AT andyc.carenet DOT org ZZZzz /,`.-'`' -. ;-;;,_
> BJC Health System |,4- ) )-,_. ,\ ( `'-'
> St. Louis, Missouri '---''(_/--' `-'\_)
> Cat Pics: http://andyc.dyndns.org/animal.html
|