Clone DB with different Instance owner & Schema

[JaneMosk]

I have a production database that I would like to recreate for support purposes in a development environment on a separate machine. Is it possible to do a dump and restore to a new database with a different instance owner and schema name than the original db.

Thanks.

 

[sathyarams]

There's not enough information in your post to give a definitive answer ..

Have a look at the FAQ section of this forum

http://www.tek-tips.com/faqs.cfm?spid=178&sfid=2767

Cheers
Sathyaram


More DB2 questions answered at

http://www.dbforums.com/f8