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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sajid Shaik MSr. System AdminCommented:
0
Kent OlsenDBACommented:
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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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 OlsenDBACommented:
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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.