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:[EMAIL PROTECTED]] > Gesendet am: Mittwoch, 20. M�rz 2002 18:10 > An: [EMAIL PROTECTED] > 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 |\ _,,,---,,_ > [EMAIL PROTECTED] ZZZzz /,`.-'`' -. ;-;;,_ > BJC Health System |,4- ) )-,_. ,\ ( `'-' > St. Louis, Missouri '---''(_/--' `-'\_) > Cat Pics: http://andyc.dyndns.org/animal.html
