db2 - copy data from one db to another

jyoung · #1 (**permalink**) 03-03-2008

I need to take data from one database to another on the same machine.
My first attempt has been using restore, but I am getting an error.
Here is the command I am trying:
db2 restore database prod into test
I get the following error:
The container is already in use.

What would be the best way to move data from one database to
another on the same machine? Are there other utilities that would work
better? DB2 version 8.1.1.56 fixpack 6. thank you.

Sprellarinn · #2 (**permalink**) 03-04-2008

Backup/Restore is the quickest and safest way to migrate the database to another machine. The error you are describing is pritty straigth forward, it states that at least one container for at least one tablespace is already in use and cannot be overwritten. This often is the case when doing a migration like this.

Take a look at redirected restore where you can redefine where to place the tablespace containers at restore time. This will be the most easy way.

jyoung · #3 (**permalink**) 03-04-2008

Thank you Sprellarinn I will take a look at the redirected restore.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how can i copy data in LINUX Machine to windows XP	bsandeep_80	UNIX for Advanced & Expert Users	2	03-27-2008 06:25 AM
copy, clear and keep to new data only	sarge	UNIX for Dummies Questions & Answers	1	10-09-2006 10:26 AM
copy prod data to QA	zomboo	UNIX for Dummies Questions & Answers	1	10-06-2004 10:24 AM
copy data from Windows to Unix any help?	odogbolu98	UNIX for Advanced & Expert Users	8	07-09-2002 12:22 PM
How to copy data file from UNIX and put it on PC	BillyT	UNIX for Dummies Questions & Answers	3	01-22-2001 10:09 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by