INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to migrate database between two computers using ibm db2 udb

How to migrate database between two computers using ibm db2 udb

How to migrate database between two computers using ibm db2 udb

(OP)
Hi buddies!


Just wanna ask, how could I possibly migrate or transfer a ibm db2 database between two computers. The source computer is tremendously slow so i've planned to use a faster computer. I've installed ibm db2 udb express edition into my new computer. My problem is that I can't transfer the database from the old pc into the new one. I've tried backup and restore using control center but the backup image wasn't detected everytime I try to restore.

Any help on this will be genuinely appreciated.

Thanks and more power to this forum!!!

DeepBlue

RE: How to migrate database between two computers using ibm db2 udb

Can the method shown here not be used?
http://www.redbooks.ibm.com/redbooks/pdfs/sg246557.pdf

You may need to create a new, valid backup.

Quote:

I've tried backup and restore using control center but the backup image wasn't detected everytime I try to restore.
There may be compatibility issues between the 2 different levels of UDB.

One way to do what you want is to unload delimited data and then reload on the new target (at least this is how we've done data migrations on other database systems).

 

RE: How to migrate database between two computers using ibm db2 udb

Could you supply more info about the 2 configurations? When you make a backup from the source computer, make sure that it is an uncompressed offline backup!
Do not rely on the control centre too much but try to make your own backup/(redericted) restore scripts.
Believe me, it works, but the syntax can be complex sometimes.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close