system copy with DB2 database

[former_member227283]

Hi,

One have some query regarding to DB2 database.

As in oracle if we want to do system copy from production to Quality. We take the backup of production and restore on quality server and do some post processing like creating OPS$.

Now my query is, like oracle can you do the steps in DB2. Can we restore the backup of production to Qualiy and make quality server up.

Thanks in advance

Thanks,

Anil Bhandary

[former_member189725]

Apart from the redirect restore that you would use to do the restore of the database , you need to do some additional stuff for setting up connectivity to the database and grant privileges to the users on the target system.

Refer to the SDN link [; for the steps .

If you find any issue in understanding , please let us know.

Edited by: Ratnajit Dey on Dec 22, 2011 12:00 PM

[former_member182505]

Hi

Check the link will help you much

Thanks

Sadiq

[Former Member]

System copy is possible in every database type - these are all RDBMS - no matter it is Oracle, DB2/DB6, MS SQL Server etc.

http://www.ibm.com/developerworks/data/library/techarticle/dm-0911sapdb2redirectedrestore/index.html

Thanks