By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Best Practices for Copying of Data Between Instances

P: n/a
A customer of mine wishes to create a test instance with the exact same
data and schema as production (1TB EDW). What is common best practice
for this? DB2MOVE? Redirected Restore? Load from Cursor?

Thanks!

Larry Edelstein
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
If it's the same OS and db2 version, why not attempt a backup from
production and restore on test?

Somebody correct me if I am wrong!!

Nov 12 '05 #2

P: n/a
You will need a redirected restore though, as the container directory
for test will have to be different than production.

Nov 12 '05 #3

P: n/a
Yes ... the names of the mount points and directories will be different.
So redirected restore would be best?

Larry Edelstein

hi****@gmail.com wrote:
You will need a redirected restore though, as the container directory
for test will have to be different than production.

Nov 12 '05 #4

P: n/a
Redirect Restore is a good way.

But if you can copy same directory of containers to test environment,
then you can recatalog it. I did it and especially when I did not have
the backup software (NBU) on the target system.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.