[closed] How do I use db2move to copy a schema to a target database which I am not connected to (for example, export schema to a file for importing later)?
Hi,
I am tasked with copying schemas from a database on a stand-alone DB2 server to a different DB2 server (with the same database name in it). When issuing the command (db2move with the -co COPY option), it's required that the target database be accessible - but that's not possible in my case. I would like to do something that creates a file that I can then move to the target machine and import. How can I accomplish this?
Thanks,
Yariv.
The question has been closed for the following reason: "Question is off-topic or not relevant" by rschoon Sep 04 '14, 2:21 a.m.
2 answers
Have you checked the document of db2move?
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.1.0/com.ibm.db2.udb.admin.doc/doc/r0002079.htm
It clearly says that the target database must be a local database when you do "db2move copy". If the target database is not accessible, why do you want to do "db2move copy"? "db2move export" will produce a file, and you should be able to do "db2 import" with the same file on the target machine.
P.S. DB2 questions should be posted on the developerWorks DB2 forum.
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.1.0/com.ibm.db2.udb.admin.doc/doc/r0002079.htm
It clearly says that the target database must be a local database when you do "db2move copy". If the target database is not accessible, why do you want to do "db2move copy"? "db2move export" will produce a file, and you should be able to do "db2 import" with the same file on the target machine.
P.S. DB2 questions should be posted on the developerWorks DB2 forum.
OK, I'll post the question there. Thanks. By the way, in the document "Data Movement Utilities Guide and
Reference (Updated January, 2013)" from IBM (I don't remember the webpage I downloaded it from, but it was from IBM), it states: "Use the db2copy utility with the -co COPY action to copy one or more schemas from a source database to a target database. [...] The source and target databases can be on different systems.".
Thanks