How do I recall to DISK a backup image from DISK for use in a redirected restore to a different server?

Hello Gurus,

I need to restore a backup image from TSM to disk so that I can use the restored disk image for redirected restore to a different server than the original server where the backup image was taken. First, can that be done? If so, how van I do this? if it can be done, can I get example of the commands to accomplish this feat?

Any help in this matter will be highly appreciated.

Thanks

Enyimba
EnyimbaAsked:
Who is Participating?
 
waynezhuCommented:
In this case, I typically do cross-node restore.
google "db2 tsm restore cross node" to see if that is what you need.
0
 
Sajid Shaik MSr. System AdminCommented:
0
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Enyimba,

Use the RESTORE command.  It's options will allow you to perform a redirected restore and even take the backup directly from TSM.

The simplest form will look like this:

  RESTORE DATABASE {db name from backup} TO {target location} [REPLACE EXISTING] REDIRECT

If you're going to overwrite an existing database, include the REPLACE EXISTING clause.

Kent
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
EnyimbaAuthor Commented:
kdo,
Yes, I am aware of this redirect restore form. But what I really need is a way to redirect restore from SERVER-A to SERVER-B.  SERVER-A has the TSM backup image that SERVER-B needs and if I can recall the backup image to disk in server-A, sftp to server-b, I can then restore to SERVER-B database. That is what I am looking for how to accomplish that!

Anyone have any idea how I can do this?

Thanks

Enyimba
0
 
EnyimbaAuthor Commented:
Shaik M. Sajid,

Thank you for the links to excellent information on TSM. Very very educational. At thhis time though, I really need to just find how to recall TSM backup copy to disk and in my search through the links you provided, I could not find any information on how I can recall to disk from TSM. If you happen to know where or how this can be done, I'd be most grateful if you point it out or give an example.

Again, thanks for the links!

Enyimba
0
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Enyimba,

You'll probably need assistance from the TSM or system administrator for this.  But just in case you can do it yourself, try this.

- Login as DB2ADMIN (or the user that owns the db2 container files) and start the TSM GUI.
- Click the Restore link (under 'Backup')
- Navigate to the folder that contains the DB2 backups.
- Check the backup that you want.
- Click Restore

Then select the destination location.  That'll put the file back on the original server.  You should be able to move it to the target server and restore from it.


Kent
0
 
EnyimbaAuthor Commented:
kdo, I wish I had immediate access to the TSM GUI but I don't. So, I am going to try to get the storage group or the TSM Admin to do this for me...stay tune how it went

Thanks

Enyimba
0
 
EnyimbaAuthor Commented:
waynezhu,

I'm looking into this cross-node restore thing...interesting and promising...
0
 
Tomas Helgi JohannssonCommented:
Hi!

From Server A issue this command inside the target directory
db2adutl extract full taken at <timestamp> database <databasename>

This will extract the backup image to the directory you are currently in.
You will also need to query the TSM server and retrieve (extract) the logs that the backup needs.
db2adutl extract logs between <log> to <log>

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002077.html?cp=SSEPGG_10.5.0%2F3-6-2-6-11
Regards,
     Tomas Helgi
0
 
EnyimbaAuthor Commented:
Thanks gys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.