how to restore the existing production db in development environment

[prave]

Hi guys ,

We have the existing db2 db in production ,

we want to restore the production database in development environment ,

db2 V8.2

Please provide me the procedure.

[Naveeds]

db2move dbname export

[vijay2082]

If your servers os and type is same then you can go for direct restore. Else use db2move export/load option to move between server which have different endianess.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0001976.htm

Cheers, Vijay

[iwaich]

If the your production environment is same as your developement evironment, you can use restore, it's very easy.

Step 1: get a backup image from you production database.
---> db2 backup db <db_name>

Step 2: Transfer this image from you production database to developement environment.
then use command --> db2 restore db <db_name>