I want to move/copy a database from one computer to the other computer by using backup dump file.
In CC, there is a wizard for create database from backup. But it won't do when backup dump is taken in other computer. (some security setting in DB2?)
What is the best way to accomplish this task?
DB2move? Or brake theis DB2 security?
I have log retain and archive on this database to be moved.

I am testing this task in order to prepare for the total hardware crash.
Please let me know which methods you use!!

This issue has been discussed umpteen times in the forum .. So, please search the forum ... The latest discussion on the topic is in

http://www.dbforums.com/t959119.html

Also, you have failed to mention the version of db2 and which OS it is on ... Please read 'Must Read Before Posting' Thread

Cheers
Sathyaram

If its DB2 UDB,

you can three ways

one from control center create DB from Backup

2nd redirect restore process
for more details refere below link
ftp://ftp.software.ibm.com/ps/produc...r/db2hae80.pdf



3rd db2relocatedb command ( db2 udb 7.2 fix pack 4 on wards)
refere command reference manuaval


library url

http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

Let me know if any questions


Raju Ennam