Restore Database - How to from 5.1.7.1 to 5.3.3 system?

[whitehall]

Hello All,



I am just wondering. We are building a new 5.3 server from scratch to replace this 5.1 system. I need to do a DB Restore on to this server in next couple of days.



I have been following the following steps and all that is left is to restore the DB. What is the correct syntax for kicking off a restore and do you have any extra hints besides these steps?



I really appreciate your help



1) Migrate all disk storage pools to tape

a. Update Stg <stgpoolname> hi=0 lo=0

2) Note the size of these storage pool volumes

a. Q Vol <volname> F=D

3) Delete the disk pool volumes associated with the storage pools

a. Delete Volume <volname>

4) Note the configuration and name of the library, devclass, drives and paths.

5) Backup the TSM database and note which volume is used for the backup

a. Backup DB Devclass=<devclassname> Type=Full

6) Note the size of the database and recovery log volumes

a. Query DBvolume

b. Query Logvolume

7) Copy the dsmserv.dsk, devconfig.out, volhist.out, and dsmserv.opt files to an alternate location



New(Target) Server



Install the TSM base server code on the new AIX machine, register licenses, and apply

ptf's as required to bring the server to same level as the source server.

9) Attach the library and drives from the old machine and run cfgmgr.

10) If the drives require that the ADSM driver be in control(i.e. 8mm, 4mm, etc.) use smit to

create the mt devices

11) Start TSM and Define the db and log volumes to be the same size or greater than the

source server

a. Define DBVol <volname> Formatsize=<size in MB>

b. Define LogVol <volname> Formatsize=<size in MB>

12) Define the library, drives, devclass and paths as they were from the source server from step 4

above

a. Define Library .....<See Admin Reference for proper syntax>

b. Define Drive .....<See Admin Reference for proper syntax>

c. Define Path .....<See Admin Reference for proper syntax>

d. Define Devclass .....<See Admin Reference for proper syntax>

13) Halt TSM

14) Copy dsmserv.opt and volhist.out to their respective locations on the target server

15) Restore the db

a. DSMSERV RESTORE DB TODATE=Today PREVIEW=No

16) After the restore completes, start the server and define the disk storage pool volumes.

a. DEFINE VOL <stgpoolname> <volname> Formatsize=<size in MB>







Is step no. 15 the correct syntax for use on a Windows TSM 5.3 server?



Thanks

 

[chad_small]

Best practice is to either upgrade the 5.1 server to 5.3 and then do a db backup and restore it to the new server OR install 5.1 code on the new server, restore the db, then upgrade the server to 5.3. I haven't tried to restore a DB to 5.3 from a lower level and I don't believe it will work. I think I tried to do that once and it failed but I can't remember, it was a long time ago.